Remove Duplicate In Excel

We have Product data in column A and you can see there are a lot of duplicates values, we want only the unique values of product.

Capture

Step 1

Select the column which contains the data and go to Remove Duplicates in Data ribbon, your duplicates will be removed in the same place.

Capture

Step 2




You will get a pop up like below

Capture

You could check/uncheck the “My data has headers” checkbox depending on your selection contains header or not. If there were more than 1 column from which you wanted to remove columns, you would have to select those columns and press OK.

Step 3

You can see that our product column does not have any duplicate values now.

Capture




Hope this helped.

 

Share The Knowledge

Random Posts

Leave a Reply