Hi, I have a list of data as follows,
A B C
1 J44 A13 A45
2 J44 B56 N67
3 B78 C67 C34
4 J44 A13 A45
5 Y84 T56 V67
I want to be able to find and highlight duplicate rows, i.e. in the list above rows 1 and 4 are duplicates, is there a way to highlight both rows? (Note my list of data carries on for 10000 rows, that is why I must find a fast efficient way to find and highlight duplicates rather than manually find them).
Bookmarks