|
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.
|
