How to Remove Duplicate Entries in Excel
Removing duplicate data in Excel
Remove records that contain duplicate values.
Excel can scan a list and search for duplicate entries. If it finds any, you can instruct Excel to remove them from the list.
1 Click in cell A6.
2 From the Data tab, choose Remove Duplicates.
3 Click the Unselect All button.
4 From the Columns section of Remove Duplicates dialog box, select First Name and Last Name.
5 Click OK. If there were records with duplicate first name and last name entries, they would be removed.
6 In the resulting dialog box, click OK to acknowledge that no duplicate values were found.