The ability to delete duplicate records in Excel 2007 is set to the data option performers (with features such as sorting and filtering)
To use this feature, the user simply selects the list of data they want to check, and when you press the "Remove Duplicates" button, the dialog box appears as shown in the following illustration:
You will see that all the column headings in the list appear in the dialog box. To delete duplicate records, simply select some or all of the headings based on your requirements, and Excel automatically filters for duplicate records. Note, however, that you are not deleting all duplicate records, but keeping one, and other records that duplicate that record will be deleted! For example, in the previous table, the same record for Name and Data is two pairs: Wang 12 and Lu 13. After you delete duplicates, they will retain only one pair. As shown in the following table:
Note that removing the duplicate record feature deletes the record completely from your spreadsheet, rather than hiding the rows. Of course, if you find that the operation is wrong, you can undo the delete duplicate record operation just now.