Originally Posted by Gef

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