Need to remove duplicates in Excel? Excel 2007 introduced the Remove Duplicates command on the Data tab of the ribbon.


1. Before you start… Make a copy of your data, since the command will delete the duplicate rows.

2. Select one cell in your table

3. Data, Remove Duplicates

4. Initially, all columns are checkmarked. Click Unselect All.

5. Choose the column where you want only unique values.

6. Click OK.

Excel will report that NN records have been removed and N records remain.

Good news: if you forgot to make a copy of the data, Undo will bring all of your data back.

For this and 511 other tips about Excel, check out Learn Excel 2007-2010 from MrExcel.