#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
Yes it is. Is there one formula to identify dupes in FIrstName LastName
Records and delete the dupes? Thank you! Gef |
#4
|
|||
|
|||
* Select the table of your data including headers, if any.
* Select Data>Remove Duplicates. * If you have headers, check "My data has headers" and the headers will be displayed in the list (rather than just the column letters. * Uncheck all but the columns you want to check for duplicates i.e. make sure just first and last name are checked. * Press OK. |
#5
|
|||
|
|||
Deleting Duplicate FN LN and Maintaining all other data in the FN LN Records that is not a dupe
Thank you for your answer. However, when I use this action it does not maintain the rest of the data. I need the duplicate rows to be deleted, but the data in each row that remains needs to stay with the FN LN.
Please see sample attached. Thxs. |
#6
|
|||
|
|||
Quote:
You are selecting the whole table when you remove duplicates, right? Not just the first and last names. If I use the Remove Duplicates, only one record remains for this contact. This record has all the same data that every other record had save for this one field. Only the first instance of this, 147, is kept. |
#7
|
|||
|
|||
Oops -- I was only selecting the FN LN. I did it correctly, and it works great!! Thank you for your patient and clear instructions!!
Best regards, Gef |
#8
|
|||
|
|||
Nice! Glad i could help!
|
Tags |
de-dupe |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Searching by Quotation Length | cheech1981 | Word | 4 | 03-14-2013 08:23 AM |
Searching A Database Two Ways | skoz55 | Excel | 3 | 11-10-2011 01:01 AM |
Searching for Word Documents | jocaan | Word | 2 | 09-08-2011 11:48 AM |
Searching hyperlinks | PuddinPie | Word | 1 | 05-27-2011 02:02 AM |
effective searching | mar999 | Office | 1 | 05-04-2011 04:51 AM |