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.