Call us Today +1 (888) 240-8088

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

Conditional Formatting in excel
Step 2: Click Data > Remove Duplicates

Conditional Formatting in excel
You should get something like this:

Conditional Formatting in excel
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:

Conditional Formatting in excel
Clicking OK should show you the results.

Conditional Formatting in excel


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.

The author:

RingLead offers a complete end-to-end suite of products to clean, protect and enhance company and contact information, leading to improved organizational efficiency, reliable business intelligence, and maximized ROI on CRM and marketing automation investments.Since 2003 RingLead has helped solve the dirty data problems of large enterprises, Fortune 500 companies and small businesses across the globe.