Microsoft Office Tutorials and References
In Depth Information
Data sorted by multiple criteria.
During an Excel sort, apostrophes (') and
hyphens (-) are ignored, unless two text
strings are the same except for a hyphen. In
that situation, the text with the hyphen is
sorted as the latter.
Easily remove duplicate records.
3. Check or uncheck the columns you want
Excel to examine.
Removing Duplicate Records
After sorting your data, you may discover you have
some records in the list more than once. You could
manually scan the data and delete the extras one
by one or, better yet, let Excel remove any
duplicate records. Follow these steps:
4. Click OK. Excel looks for and removes
duplicates. A message tells you how many
duplicates were removed (if any) and how many
unique values remain. In Figure 11-28, you
see that five duplicate records were found.
5. Click OK.
Select or click in the list of data you want to
2. Choose Data>Data Tools>Remove Duplicates.
The Remove Duplicates dialog box appears
(see Figure 11-27).
See how many records Excel removed.