Thread: [Solved] Searching for Dupes
View Single Post
 
Old 03-02-2015, 09:46 AM
gebobs gebobs is offline Windows 7 64bit 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