Hi, I have a workbook with 8 different fields as column headers and wish to find any instances where all 8 of these fields are identical.
i.e. I know there are several rows (out of several hundred) in which every column is identical and wish to distinguish these from the remaining data.
Is there a way to identify only these duplicates?
I don't know how well I've explained this......a simple example would be :
Postcode - Cond
N1 8DN - good
N1 8DB - good
N1 8DN - good
N1 8DN - bad
And i'd want it to show that rows 1 and 3 were duplicates
Thanks
Bookmarks