Forum Discussion
Sorting out duplicates.
Filter by color (From your conditional formatting), delete the visible rows and then remove the filter.
With all of your data in a column (ideally a table), select a single cell in the column with the duplicates. From the Data ribbon, use the Remove Duplicates button. It will prompt for acceptance of the current column and in on click your duplicates will be removed.
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
