Forum Discussion
How do I prioritize preferred Duplicate rows to keep, while using the Remove Duplicates function?
Hello, I have a sheet of 3000 rows; ~300 of them are duplicate entries to be removed. Most of my rows have a State abbreviation assigned to them, but a few hundred have a placeholder abbrevia...
Data > Remove Duplicates always keeps the first (top) of a set of duplicate entries, and deletes the ones below.
So if you can sort your data so that the placeholder state abbreviations are at the bottom, you'll get the result you want. You might - for example - use ZZ as placeholder.
