Remove Duplicate values in excel

In the previous article is about highlight duplicate values in excel only show you duplicate data. But we have huge data which contain many duplicate values, these data need to be removed for our accuracy. during the entry, we may enter the same data more than one time. if data is huge we have to consume too many time to find out and remove duplicate values in excel. excel make our work easy find finding and remove Duplicate values

Remove Duplicate values in excel

In my example I have some product with sales area north, west and east here some data are duplicate. and I am going to remove duplicate data which all data are matched
we can also remove selected matched data only
Eg. If we think that we have to enter only product and area once in data we do not need to match 1st quarter, 2nd quarter and total

To Remove Duplicate values in excel
1. Go to the data tab
Remove Duplicate values in excel

2. Click on Remove duplicate
Remove Duplicate values in excel

3. select column to match
Remove Duplicate values in excel

4. Click OK after select column
Remove Duplicate values in excel


This is the way how can you remove duplicate values in excel.
Remove Duplicate values in excel

0 Comments