I have a large table of about 50 columns. I know some of the rows are exact duplicates of each other.
I can use the Remove Duplicates feature to delete those rows, but before I do I need to know which rows are duplicated..
Is there a way to highlight duplicate rows? Like Conditional Formatting does, but the whole row has to match another.
Is there a way to filter duplicate rows?
Maybe there's an easy way to concatenate all 50 cells in the row into a new cell at the end of the row. Then I could use Conditional Formatting on that last column to find the duplicates, and filter them.
I'm open to using VBA, but offhand I can't think of a method.
Thanks!
Bookmarks