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.


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.


Step 2

You will get a pop up like below


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.


Hope this helped.


Share The Knowledge

Random Posts

Leave a Reply