03-02-2015, 06:00 AM
|
Expert
|
|
Join Date: Mar 2014
Location: Atlanta
Posts: 837
|
|
Quote:
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
|
Is it your intention to remove duplicates? Excel can do that easily. Data>Remove Duplicates.
|