Searching for Dupes
Hello,
The formula I am using is marking all the duplicates, but I need it to leave the first record (do not mark the first record as a dupe)-- but mark the duplicates after that.
I want to keep only 1 unique record of first name, last name. Here's the formula I used:
=IF(OR(AND(C4=C5,D4=D5),AND(C4=C3,D4=D3)),"Duplica te Contact Name","")
Please help!
Thank you in advance,
Gef
|