Forum Discussion
Sorting out duplicates.
Filter by color (From your conditional formatting), delete the visible rows and then remove the filter.
Is there a way to highlight the duplicates prior to deleting them so I can verify the information?
You can highlight both of the columns, and from the Data ribbon, select Conditional Formatting. From that dropdown menu, select Highlight Cell Rules > Duplicate Values. Once you confirm the color option it will show you the duplicates in both columns.
WOW...thanks for the speedy response. I have a spreadsheet of names for our holiday catalog. I read your post but I am a little confused (Sorry). Do I need to copy the address column to do the conditional formating?
Thanks in advance for your assistance. I attached a ship of my data list
If you just need to highlight the duplicates without comparing with another column, you can simply select the single column and check for duplicates that way. Then, with your data in a table, you can just sort by color and manually delete them. You alternatively could just use the Remove Duplicates option. This original post was a little different from your question, I think. But I'm happy to try and help.
