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 12

Step 2: Click Data > Remove Duplicates

Conditional Formatting 13

You should get something like this:

Conditional Formatting 14

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 15

Clicking OK should show you the results.

Conditional Formatting 16


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.

63 thoughts on “Remove Duplicate Records using Microsoft Excel”

  1. Greetings from Carolina! I’m bored to death at work so I decided to
    browse your blog on my iphone during lunch break. I
    love the information you present here and can’t wait to take a look when I get home.
    I’m surprised at how quick your blog loaded on my cell phone ..
    I’m not even using WIFI, just 3G .. Anyways, wonderful blog!

  2. Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword….wait there’s even more Now what if i told you there was a simple WordPress plugin that does all the On-Page SEO, and automatically for you? That’s right AUTOMATICALLY, just watch this 4minute video for more information at. Seo Plugin

  3. Howdy just wanted to give you a quick heads uup
    and let you know a few of the pictures aren’t loading properly.
    I’m not sure why but I think its a linking issue.
    I’ve tried it in two different web browsers and both show
    the same outcome.

  4. Good day! I could have sworn I’ve been to this blog befokre but after going through
    a few of the articles I realized it’s new to me. Regardless, I’m definitely happy I
    found it and I’ll be book-marking it and checking back regularly!

  5. I was curious if you ever thought of changing the page layout of your site?
    Its very well written; I love what youve got to say. But maybe you
    could a little more in the way of content so people could connect wit it better.
    Youve got an awful lot of text for only having one or two images.
    Maybe you could space it oout better?

  6. you’re actually a good webmaster. The website loading velocity is amazing.
    It sort of feels that you’re doing any distinctive trick.
    Furthermore, The contents are masterwork.
    you have performed a great process in this matter!

  7. Though players do not physically need to race on ground or water but they can experience the real life playing online.
    The remaining cards are known as the heel and it is from this deck that players will “fish”.
    Assist citizens to land planes, and help them get to their destinations.

Leave a Reply

Your email address will not be published.