Microsoft Office Forums Searching for Dupes
 Register FAQ Search Today's Posts Mark Forums Read

#1
03-01-2015, 08:07 PM
 Gef Mac OS X Office for Mac 2011 Novice Join Date: Jan 2015 Posts: 11
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","")

Gef
#2
03-02-2015, 06:00 AM
 gebobs Windows 7 64bit Office 2010 64bit 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.
#3
03-02-2015, 06:15 AM
 Gef Mac OS X Office for Mac 2011 Novice Join Date: Jan 2015 Posts: 11

Yes it is. Is there one formula to identify dupes in FIrstName LastName
Records and delete the dupes?

Thank you!

Gef
#4
03-02-2015, 06:47 AM
 gebobs Windows 7 64bit Office 2010 64bit Expert Join Date: Mar 2014 Location: Atlanta Posts: 837

* 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
03-02-2015, 09:04 AM
 Gef Mac OS X Office for Mac 2011 Novice Join Date: Jan 2015 Posts: 11
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.

Thxs.
Attached Files
 DataSampleExcelForum.xlsx (40.7 KB, 8 views)
#6
03-02-2015, 09:46 AM
 gebobs Windows 7 64bit Office 2010 64bit Expert Join Date: Mar 2014 Location: Atlanta Posts: 837

Quote:
 Originally Posted by Gef 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.
I'm not following you. What data is not "maintained"? For example, there are several records for Hussein Aboulezz. So far as I can see, the only difference among all the records is the "Excel Contact Serial Number".

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
03-02-2015, 10:14 AM
 Gef Mac OS X Office for Mac 2011 Novice Join Date: Jan 2015 Posts: 11

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
03-02-2015, 12:48 PM
 gebobs Windows 7 64bit Office 2010 64bit Expert Join Date: Mar 2014 Location: Atlanta Posts: 837

 Tags de-dupe

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post cheech1981 Word 4 03-14-2013 08:23 AM skoz55 Excel 3 11-10-2011 01:01 AM jocaan Word 2 09-08-2011 11:48 AM PuddinPie Word 1 05-27-2011 02:02 AM mar999 Office 1 05-04-2011 04:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:41 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top