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

Подписаться 9 тыс.

Просмотров 69 тыс.

50% 1

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 RU-vid Channel? You should be using TubeBuddy!
www.tubebuddy....
The Headset I Use for My RU-vid Videos - Jabra Evolve UC40 Headset
amzn.to/2UBPxia
RU-vid 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!

Опубликовано:

20 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 102

@TrainerPam 6 месяцев назад

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

@Jazzy_Waffles Месяц назад

This helped SO much. Not only did you provide the correct formula, and explained it as you were going, but, you beat an AI I was using to help me. Thank you SO much!

@unorthodoxbasketball 11 дней назад

I appreciate the thorough explanation! I'll definitely use this in my workflow!

@housefulagentnetwork Год назад

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

@ukramedia 3 года назад

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

@trinitys.7833 6 месяцев назад

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”

@jeremysaunders3631 2 года назад

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

@dr.prachichhimwal406 2 года назад

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

@cessabaniqued1219 3 года назад

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

@TheProductiveEngineer 3 года назад

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

@aseathompson4996 2 года назад

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

@damarodriguez807 Год назад

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

@Jen-ey6iz 3 года назад

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. Ⓣⓗⓐⓝⓚⓢ

@janellerobinson696 3 года назад

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

@TheProductiveEngineer 3 года назад

Glad it was helpful!

@KushVyas-m6c 7 месяцев назад

Thank you for making it simple to learn.

@qualitysurgicalstvm3614 Год назад

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

@mmkariina Год назад

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

@AuthenticityAndPurpose 4 месяца назад

Great simple explanation. Thank you!

@jasonmccammon3608 2 года назад

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

@ritadodhl8476 2 года назад

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

@DeanMillersg 2 месяца назад

Truly amazing tutorial. Thanks so much.

@n1guild 4 года назад

Exactly what I was looking for, cheers mate!

@TheProductiveEngineer 4 года назад

No problem 👍

@stanleefangirl 6 месяцев назад

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

@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.

@ianmacdonald1075 3 года назад

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

@maryreed1158 6 месяцев назад

Very helpful and easy to follow. Thanks

@borachhun1505 4 месяца назад

Thanks! this helped me fixed my error

@TheOneAndOnlyDon Год назад

Thanks, this is simple and really helpful.

@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.

@hemanjaligunimini2356 3 года назад

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

@berlyngallardo2867 2 года назад

THANK YOU! This was so helpful!

@milesv64436 3 года назад

Very helpful and easy to follow guide.

@TheProductiveEngineer 3 года назад

Glad it was helpful Myles!

@james98731 3 года назад

This will save hours for me ,thank you mate

@maryanncastillo5468 2 года назад

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

@creativitymatterspodcast Год назад

Very helpful. Thanks!

@mohamud11 3 года назад

Very useful, Thank You.

@TheProductiveEngineer 3 года назад

You're welcom Mohamud

@jayaprakashc4192 3 года назад

Thanks a lot. Could able to understand easily

@gogo13mo 7 месяцев назад

Good tutorial, keep up the good work!

@chandlerelyse9822 4 года назад

This was so helpful!

@TheProductiveEngineer 4 года назад

Thanks Chandler!

@abcrose5671 3 года назад

Thanks for this useful information.

@TheProductiveEngineer 3 года назад

Glad it was helpful!

@mdh5447 2 года назад

Thankzzz, clear explanation

@joshuakapuku1035 Год назад

thank you you are a life saver

@kevin.grosskopf Год назад

How can I check 2 different pages?

@aalavado 3 года назад

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

@TheProductiveEngineer 3 года назад

lol thanks Andrew

@MotivateX-official 3 года назад

THANKS FOR HELP SIR.

@TheProductiveEngineer 3 года назад

Most welcome

@keremels Год назад

Thanks for this! Great help :)

@drewdavis623 3 года назад

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 3 года назад

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

@mayolgeralds.9157 Год назад

thanks, it helps me a lot

@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.

@marcodelvalle3334 3 года назад

really helps, thank you very much!

@alyssasantiago2942 4 года назад

Awesome! Thanks!!

@TheProductiveEngineer 4 года назад

You bet!

@ynacastillo Год назад

Thank you so much!!!

@jonathanderain8221 Год назад

You'r e a life saver

@timruiz8848 3 года назад

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 3 года назад

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