Remove Duplicates

Remove Duplicates

In this first exercise, we have two lists exactly the same. We're going to remove duplicates from one of the lists and then compare it with the original list to see what was removed. 

How to Remove Duplicates

The process of removing duplicates is very simple. 

You're going to click anywhere within the data where you would like to remove duplicates. 

I'm going to click on this second list anywhere within the data. 

Then I'll navigate over to the Data tab on the ribbon. 

The Data Tools group and then look for remove duplicates. If the width of your application is wide enough, you'll actually see the text to remove duplicates or you'll look for this icon. If you hover your mouse over any of the icons on the ribbon, usually a Pop-Up will come up letting you know that you're in the right place. 

So with the cell selected within the data where I'd like to remove duplicates, I'm simply going to click remove duplicates. 

The column that needs to be selected is already selected, I see that it's checked here by data does have headers, so I'm not going to include the headers as part of the criteria for removing duplicates. 

Excel is going to look throughout the entire list and when it finds the second value that is the duplicate, it will remove it but keep the original value.

I'll click. OK. Excel displays a progress report letting me know that two duplicate values have been found in remove. And now I have eight unique values remaining. I can simply click OK.

And if I compare my unique list with the original list, I'll see that Mabel and Maria were the duplicates that were removed from the list. The second list. 

Exercise 2

So let's take a look at an exercise that we would practice in class related to this if I go to the next tab. Now we've increased the level of difficulty. We have multiple columns in multiple rows. The process, though, is pretty much the same. I'm going to select a cell anywhere within the data. There's no need to select the entire region.

I'll go to the data tab. I'll head over to the data tools group. I'll click remove duplicates. Immediately, I can see Excel did grab all the information. Also, my data has headers, if that was not checked, then my data would look like this. I want to exclude the headers from the removed duplicates process, so I'll click the checkbox there. And the best bet is to make sure all the columns are selected because you may want to check each and every value in one row to see if it's duplicated by each and every value in another row. In this case, the entire row is a unique value, and that's your best bet.

I'll now click ok. Excel gives me a progress report that tells me that for duplicate values were found to remove eleven eighty-nine unique values remain. I'll click.

OK, I can go into the spreadsheet type 4 press enter and that solves that particular task.

Recap

So that's how you remove duplicates.

Simply select the cell anywhere within the data. Go to the Data tab in the data tools group. You'll click on remove duplicates and click OK.