Hi there,

Having a bit of trouble with isolating duplicates - the conditional formatting approach doesn't seem to work.

In short - I have 70,000+ records over 8 columns. I have removed duplicates across all 8 columns, but I now need to isolate duplicates that match 7/8 columns.

I can remove these by unticking one of the columns using the remove duplicates function, but this won't let me isolate them.

The duplicates (98 of them) will contain two versions, with different numbers in the column that need to be checked manually for the correct one - subsequently removing the erroneous version.

If anyone has any ideas on how best to approach this, I'd be eternally grateful!

Many thanks, Tom