Microsoft Office Tutorials and References
In Depth Information
At the Risk of Repeating Yourself: The Remove Duplicates Option
Last Name
First Name
Age
Jones
Ed
34
Walters
Gary
21
Jones
Ed
34
Albert
Ida
26
Troy
Helen
51
Jones
Grace
42
Figure 6–46. Broken record: Two Ed Joneses
You added the Age field, because there could well be two persons in the database named Ed Jones—with
different ages. Then click anywhere in the table and click Remove Duplicates on the Tools Button group.
You’ll see (Figure 6–46):
Figure 6–47. Duplication search criteria
Note that by default all three fields are checked, meaning: if we click OK, Excel will remove only
those records which contain duplicate data in all three fields. It’s clear in our table that the two records
of Ed Jones are indeed identical across all three.
Click OK, and you’ll see (Figure 6–47):
Search JabSto ::




Custom Search