Find Duplicates in a List of Names
Learn how to find duplicates in a list of names using Google Sheets without deleting them. This video covers the MATCH function and conditional formatting to identify repeated entries effectively.
I have a list of names here and I want to find all the duplicates. I don't want to delete the duplicates in Google Sheets, in Data , Data Cleanup , there is the Remove Duplicates option. What this does is deletes all of the duplicates. But what we want to do is we just want to find it. Maybe this is a list of signups and we want to know who signed up twice. There's other reasons why we might not want to delete immediately all of the duplicates. What I like to do is look for matches equals match the search key is the name that I'm searching for. Range is B colon B. Search type zero to get an exact match and it will find itself And this is what we want. We want 5, hit OK on Suggested Autofill . We'll see Cal Clay is 7, but it's on row 14. But we don't have to actually look through all of this. We can say match minus row. Now we have a bunch of zeros, except for where there is a duplicate. How to Find Duplicates Discover Misspelled Duplicates How to Find Fuzzy Matches in Google Sheets
We can do conditional formatting . You could also sort this. Sort A to Z . . duplicates here. We have Kazon Rush, Cal Clay, yes, Mary Best, Cal Clay, and Kazon Rush. Those are the duplicates in this sheet. Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell Discover Misspelled Duplicates Find Duplicates in Other Column