I know how to use the Delete Duplicates option on the ribbon. But, I suspect that it is deleting rows it shouldn't. Is there a way to show duplicate rows? I tried conditional formatting. But since every item in every column will repeat at some point it just painted the worksheet pink.
Bookmarks