When you have data and you want
to remove duplicate value from excel, it is very easy in excel from “Remove Duplicates”
1.
select Range from spread sheet
2.
Click the Data tab.
3. Click Remove Duplicates from
the Data Tools
You can select the column from
which you want to delete duplicate values
example:
- Select “Name” Check box then the result will shown below.