Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-01-2015, 08:07 PM
Gef Gef is offline Searching for Dupes Mac OS X Searching for Dupes Office for Mac 2011
Novice
Searching for Dupes
 
Join Date: Jan 2015
Posts: 11
Gef is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 03-02-2015, 06:00 AM
gebobs gebobs is offline Searching for Dupes Windows 7 64bit Searching for Dupes Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by Gef View Post
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.
Reply With Quote
  #3  
Old 03-02-2015, 06:15 AM
Gef Gef is offline Searching for Dupes Mac OS X Searching for Dupes Office for Mac 2011
Novice
Searching for Dupes
 
Join Date: Jan 2015
Posts: 11
Gef is on a distinguished road
Default

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

Thank you!

Gef
Reply With Quote
  #4  
Old 03-02-2015, 06:47 AM
gebobs gebobs is offline Searching for Dupes Windows 7 64bit Searching for Dupes Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

* 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.
Reply With Quote
  #5  
Old 03-02-2015, 09:04 AM
Gef Gef is offline Searching for Dupes Mac OS X Searching for Dupes Office for Mac 2011
Novice
Searching for Dupes
 
Join Date: Jan 2015
Posts: 11
Gef is on a distinguished road
Default 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.
Attached Files
File Type: xlsx DataSampleExcelForum.xlsx (40.7 KB, 8 views)
Reply With Quote
  #6  
Old 03-02-2015, 09:46 AM
gebobs gebobs is offline Searching for Dupes Windows 7 64bit Searching for Dupes Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by Gef View Post
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.
Reply With Quote
  #7  
Old 03-02-2015, 10:14 AM
Gef Gef is offline Searching for Dupes Mac OS X Searching for Dupes Office for Mac 2011
Novice
Searching for Dupes
 
Join Date: Jan 2015
Posts: 11
Gef is on a distinguished road
Default

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
Reply With Quote
  #8  
Old 03-02-2015, 12:48 PM
gebobs gebobs is offline Searching for Dupes Windows 7 64bit Searching for Dupes Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Nice! Glad i could help!
Reply With Quote
Reply

Tags
de-dupe

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching for Dupes Searching by Quotation Length cheech1981 Word 4 03-14-2013 08:23 AM
Searching for Dupes Searching A Database Two Ways skoz55 Excel 3 11-10-2011 01:01 AM
Searching for Dupes Searching for Word Documents jocaan Word 2 09-08-2011 11:48 AM
Searching for Dupes Searching hyperlinks PuddinPie Word 1 05-27-2011 02:02 AM
Searching for Dupes effective searching 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.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft