Removing duplicates from worksheet data in Excel 2007 is quick and easy. You don’t need to write a macro as in Excel 2003.Most of us face the problem of duplicate entries in our Excel worksheets. In Excel 2007 the process of removing duplicates is quick and easy. In Excel 2003 you needed to write a complicated macro involving a ‘dowhile’ nested loop. Because you are permanently deleting data, it’s a good idea to copy the original range of cells or table to another worksheet or workbook before removing duplicate values.
Select the range of cells, or make sure that the active cell is in a table.
On the Data tab, in the Data Tools group, click Remove Duplicates.
A message is displayed indicating how many duplicate values were removed and how many unique values remain, or if no duplicate values were removed.
The training video shows exactly how the feature ‘remove duplicates’ in Excel 2007 is implemented.
Remove Duplicate Data Records in Excel