HOW TO FIND DUPLICATES IN GOOGLE SHEETS | Finding and Highlighting Duplicates in Google Sheets

This video is about how to find and highlight duplicate entries in Google Sheets. If you like this video, please hit the "Like" button and if you want to see more of my videos on productivity apps and tutorials, subscribe to the channel.
GENERAL RESOURCES
The Productive Engineer Website
theproductivee...
Starting a Blog, check out my blog post on how to get started
theproductivee...
List of My Favorite Productivity Books
theproductivee...
RECOMMENDED TOOLS
Do You Have a RUclips Channel? You should be using TubeBuddy!
www.tubebuddy....
The Headset I Use for My RUclips Videos - Jabra Evolve UC40 Headset
amzn.to/2UBPxia
RUclips TIPS PLAYLIST
How to Backup Your Evernote Notes
• How to Backup Your Eve...
How to Use the Notion Web Clipper
• How to Use the Notion ...
How to Embed Codepen into Notion
• How to Embed Codepen i...
NOTE: This description contains affiliate links that allow you to find the items mentioned in this video and support the channel at no cost to you. While this channel may earn minimal sums when the viewer uses the links, the viewer is in NO WAY obligated to use these links. Thank you for your support!

[@TrainerPam]

You made that so incredibly clear and with just enough of the "why" added to the "how". Thanks so much!!

[@housefulagentnetwork]

Loved how you explained the 'why'. It helped me to understand it better. Thanks!

[@DeanMillersg]

Truly amazing tutorial. Thanks so much.

[@jeremysaunders3631]

I come back to this video so so so often - thank you so much for posting this, it's been a lifesaver!

[@cessabaniqued1219]

Omygod! This video makes my life 101% easierrrr. I love ittt!!! I subscribedddd immediately. Thank you

[@TheProductiveEngineer]

Thanks for subbing Cessa! Glad the video was helpful to you

[@Jen-ey6iz]

I wish everyone would just explain these things like you did. Just tell me three things-where to type, what to type, and a quick summary of why before I click or hit enter. Ⓣⓗⓐⓝⓚⓢ

[@dr.prachichhimwal406]

Thank you so much. Straight to the point in simplistic manner.

[@ukramedia]

super helpful! Thank you! I wish more videos were like yours. Quick and to the point.

[@trinitys.7833]

It did! THX a lot for sharing this. And I'd also like to share another simple way to find or remove duplicates with you guys!
It's very simple to complete this if you use WPS Office, which only takes 2 steps:
1. select the range of your values
2. click “highlight duplicates”< “set”
or if you wanna remove duplicates, then step 2 would be:
click “highlight duplicates”< “remove duplicates”

[@aseathompson4996]

This tutorial saved my professional life! Thank you so much!

[@borachhun1505]

Thanks! this helped me fixed my error

[@damarodriguez807]

Thank you! The easiest instructions and demo I have seen!

[@mmkariina]

Brother you are AMAZING, AWESOME, FANTASTIC! Just know you helped a friend! Bless you in all you do! Thank you so so much!

[@qualitysurgicalstvm3614]

Thank you i fix My Purchase Requisition sheet duplication problem😇😇😇😇😇😇😇😇

[@janellerobinson696]

You explanations are so clear and easy to understand. Thank you!

[@TheProductiveEngineer]

Glad it was helpful!

[@AuthenticityAndPurpose]

Great simple explanation. Thank you!

[@jasonmccammon3608]

Thanks buddy for explaining it. Cuz other people don't. Task acheived.

[@user-ku6ui7oe7t]

Thank you for making it simple to learn.

[@ritadodhl8476]

WOW THANK YOU !! made my work flow easier .. very clear and to the point.

[@gogo13mo]

Good tutorial, keep up the good work!

[@maryreed1158]

Very helpful and easy to follow. Thanks

[@stanleefangirl]

Thank you for the video, my entire column was highlighted with this formula. Any suggestions?

[@ianmacdonald1075]

Thanks - clear, simple and it worked for me exactly as explained

[@servlink]

Want to just add a quick side note. If your table has headers, you have to include the header row number. I tried to skip it and start straight into the information and was given random values that were highlighted. Always start with the first row.

[@TheOneAndOnlyDon]

Thanks, this is simple and really helpful.

[@n1guild]

Exactly what I was looking for, cheers mate!

[@TheProductiveEngineer]

No problem 👍

[@maryanncastillo5468]

Thank you so much, Sir. Clear and easy to understand.😊😊🙂🙂

[@mylesw8940]

Very helpful and easy to follow guide.

[@TheProductiveEngineer]

Glad it was helpful Myles!

[@randertonyo]

Is there a way to find values that meet a range of criteria? For example, where there are more than 8 duplicate values, but less than 15 in a column? BTW, EXCELLENT video.

[@james98731]

This will save hours for me ,thank you mate

[@TheShaggyfrog]

Thank you for this

[@chandlerelyse9822]

This was so helpful!

[@TheProductiveEngineer]

Thanks Chandler!

[@berlyngallardo2867]

THANK YOU! This was so helpful!

[@myghtsolidarios9911]

thanks. big help

[@abcrose5671]

Thanks for this useful information.

[@TheProductiveEngineer]

Glad it was helpful!

[@jayaprakashc4192]

Thanks a lot. Could able to understand easily

[@mohamud11]

Very useful, Thank You.

[@TheProductiveEngineer]

You're welcom Mohamud

[@drewdavis623]

Can you help me? How would I do this if I only wanted to highlight duplicates next to each other? For example, if I had a data set with 10,8,8,2,9,8 in a column, how do I get the first two eights to be highlighted, but no the one on its own? Great vid btw!

[@TheProductiveEngineer]

Hi Drew. I don't know how to do that but let me do some research to see if it is possible

[@joshuakapuku1035]

thank you you are a life saver

[@creativitymatterspodcast]

Very helpful. Thanks!

[@joefromdc]

Only one recommendation, pls zoom in on the formula next time thanks for the video

[@alyssasantiago2942]

Awesome! Thanks!!

[@TheProductiveEngineer]

You bet!

[@mdh5447]

Thankzzz, clear explanation

[@MotivateX-official]

THANKS FOR HELP SIR.

[@TheProductiveEngineer]

Most welcome

[@aalavado]

Thank you so much!!!!! And by the way that Wham song isn’t so bad lol

[@TheProductiveEngineer]

lol thanks Andrew

[@mayolgeralds.9157]

thanks, it helps me a lot

[@keremels]

Thanks for this! Great help :)

[@johnclark1163]

Thank you bro

[@marcodelvalle3334]

really helps, thank you very much!

[@enchantinglysimple]

If I have two workbooks which I'm tracking similar data, how would I go about highlighting duplicates from one spreadsheet that I have in another spreadsheet? Any help would be appreciated. Thanks.

[@ilyashachimi7137]

THANKS!

[@jonathanderain8221]

You'r e a life saver

[@edcooper1471]

Thanks!

[@TheProductiveEngineer]

You’re welcome Ed and thank you so much 😊

[@BustedLeaf]

Thank you.

[@jogaritips9087]

thanks you

[@joshmerlabao1336]

UPPPPP BEST VID

[@TheProductiveEngineer]

Thanks Joshmer!

[@ynacastillo]

Thank you so much!!!

[@hemanjaligunimini2356]

Instead of single column.. Is it not workable for whole sheet? And is it workable if there any merged cells?

[@user-mo8vp6pw9x]

thank you

[@premswami3262]

THANKS SIR

[@jonathanderain8221]

Thanks man.

[@TheProductiveEngineer]

Happy to help Jonathan

[@nomanahmed9168]

Helpful, Thanks

[@bokinaladivyajyothi9075]

Thanks for sharing

[@TheRelationshipGuide500]

Thankyou so much ❤️...

[@TheProductiveEngineer]

You're welcome 😊

[@kevin.grosskopf]

How can I check 2 different pages?

[@PavelVokral]

hi friends, cannot explain why, in ma case i had to write a formula WITHOUT equal mark at the beginning....maybe some improvement in GS...not sure

[@kirtimishra7287]

It was helpful

[@TheProductiveEngineer]

Thanks Kirti

[@genz369hypesquad]

Thanks

[@labibabari]

thank you so much!

[@timruiz8848]

Cool thanks. Question: What would be the purpose of creating this particular organized list of what audio files that you own? I am a musician and am just curious because it seems tedious and something that is already saved and organized via iTunes or whatever, right(?)

[@TheProductiveEngineer]

I just used the audio files because I knew I had duplicates and it was easy to create a spreadsheet from it TBH

[@danielebagnagatti5425]

thank you,!

[@criconinvestments7723]

How d'you do the entire sheet?

[@jamesdean44775]

What about two columns?

[@Timeuw]

It said, "Invalid formula
". Did everything you did :(

[@hqproductionpotfolio2067]

Invalid formula

[@redf419]

=COUNTIF(A:A;A1)>1

[@pawebiaas7359]

NOONE SHOW ITS ";" NOT ","

[@redf419]

@@pawebiaas7359 Thats why i wrote this Comment 🤣

[@julimarlow7264]

your volumn is so low, I had to turn mine up to full blass to hear you.

[@ianmacdonald1075]

Thanks - clear, simple and it worked for me exactly as explained

[@TheProductiveEngineer]

Thanks Ian. Glad the tutorial helped you.

[@raedogaili9091]

Thanks

[@TheProductiveEngineer]

You're welcome Raed!