Microsoft Office Tutorials and References
In Depth Information
Removing Duplicate Rows
Figure 33-2: Removing duplicate rows is easy.
If your data is not in a table, use the Data➜Data Tools➜Remove Duplicates command
to display the Remove Duplicates dialog box.
Understand that duplicate values are determined by the value displayed in the cell —
not necessarily by the value stored in the cell. Assume that two cells contain the same
date: One date is formatted to display as 5/15/2010, and the other is formatted to
display as May 15, 2010. When removing duplicates, Excel considers these dates to be
Figure 33-3: Excel tells you the result of deleting duplicate rows.