Note: For help with this article see the image to the right.
Related article: Find Duplicates in Excel with Conditional Formatting.
To remove duplicate data records from a database in Excel 2007 :
- Click on any cell in the database.
- Click the Data tab on the Ribbon.
- Click on the Remove Duplicates option.
- Doing so will select all the data in the database and open the Remove Duplicates dialog box.
- When the dialog box opens, all of the column headings are selected by default.
To remove only those records from the database that match another record exactly:
- Leave all column headings selected and Click OK.
To remove records from the database that have duplicate data in only one or more columns:
- Remove the check marks from those columns you do not want to compare.
- Click OK
Note: If you remove the wrong data, click the Undo button on the Quick Access toolbar or press CTRL + Z on the keyboard to get your data back.
Related Articles
