The previous post on Excel describes how to find and sort duplicates within an Excel file. This method takes it one step further and uses the Remove Duplicates function within Excel to remove existing duplicates within your spreadsheet.
Say, for example, that you’ve already bought two lists without realizing that there are overlapping records between the lists. Without using the Remove Duplicates feature, you would have to compare the two lists manually and delete them one by one. Instead, the better option would be to compile the two lists, and use the Remove Duplicates feature that would go through the entire sheet and do the deduping for you.
*This function is only available in the 2007 and 2010 version of Excel.
Step 1: Highlight the entire sheet
Step 2: Click Data > Remove Duplicates
You should get something like this:
Step 3: Since we want to check for duplicates within all three columns, we will leave the three columns checked off. Make sure that “My data has headers” is checked off as well if you have headers. Click OK and you should get a prompt:
Clicking OK should show you the results.
Save even more time
Now, this is something that makes your life a little easier, but if you want to make your life a lot easier try Unique Upload. If you are using Salesforce, Marketo, Pardot, Eloqua, Act-On or Genius, Unique Upload can dedupe existing lists and prevent the creation of duplicate records in CRM/marketing automations as they are imported into your database. This can eliminate “staring and comparing” from your vocabulary forever.