Microsoft Office Tutorials and References
In Depth Information
At the Risk of Repeating Yourself: The Remove Duplicates Option
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):