Remove duplicate combinations in your data [quick tip]

Posted on August 7th, 2015 in Excel Howtos - 5 comments

By now, we know how to remove duplicates from data. You can use the Remove Duplicates button to do that.

But do you know that we can use remove duplicates button to get rid off duplicate combinations too?

Remove duplicate combinations – Tutorial

To remove duplicate combinations in your data, just follow below 4 steps:

  1. Select your data
  2. Click on Data > Remove Duplicates button
  3. Make sure all columns are checked
  4. Click ok and done!

See this demo:

Remove duplicate combinations in your data - how to?

 

How to remove duplicate combinations in some of the columns

If you just want to remove duplicate combinations of Product & Store alone, you can still use Remove Duplicates feature.

This time, select all 3 columns, but check only first 2 columns in the remove duplicate screen. That should do the trick.

Remove duplicate combinations using Excel - tip

More ways to deal with duplicate data

Duplicate data is not a unique problem, its everywhere. That is why at Chandoo.org, we have a plethora of tips, tutorials & videos to help you deal with the problem. Check out below links to learn more.

How do you deal with duplicates?

I use remove duplicates button every time I get raw data.  It is such a time saver. When I want a more automated solution, I use formulas or pivot tables to knockoff the duplicates.

What about you? How do you deal with duplicates in your data? Please share your tips by posting a comment.

This post is part of Awesome August Excel Festival.

Written by Chandoo
Tags: , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

5 Responses to “Remove duplicate combinations in your data [quick tip]”

  1. Heather says:

    I have one file that is more database (displaying product data such as warehouse location, description, etc), and that is where I probably deal with duplicates the most.

    Instead of simply deleting them, I need to look for what has changed (or verify that there are no changes). My solution is to sort the file alphabetically, and then highlight duplicates in the item number column. Once I've located the duplicates, I then compare (using formulas) all of the columns to indicate any differences in the duplicate values' rows.

  2. Mustafa says:

    Using advanced filter to create a new distinct version of the data.
    Link the list to MS Access and create a new distinct list from there.

  3. Mustafa says:

    Using advanced filter to create a new distinct version of the data.
    Link the list to MS Access and create a new distinct list from there.

  4. Danny Walls says:

    I need help with loading and uploading csv files for e commerce. How to is most important. Everyone says it is necessary but no one shows you how to do it.

  5. Pranav Anand says:

    Hi,

    I have come across where i have o remove the duplicates from case sensitive data. and i never found any trick or method for this.
    Can anyone guide me how to do this.

Leave a Reply