Coronavirus (COVID-19) information: Live classes available in-person or online from our fully vaccinated instructors. Learn more about our reopening.


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.