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.

Take a class from the authors of this tutorial

See available Excel classes and learn from the expert instructors at American Graphics Institute. In-person classes at our locations, online courses, or private training is available.

See Courses

Tutorials Category: Excel Tutorials

These tutorials are created by and the team of expert instructors at American Graphics Institute.