Microsoft Office Tutorials and References
In Depth Information
Remove Duplicate Values from a Table
Chapter 5: Analyzing Excel Data
The Remove Duplicates
dialog box appears.
4 Select the check box
beside each field that you
want Excel to check for
5 Click OK.
Excel deletes any
duplicate records that it
Excel tells you the
number of duplicate
records that it deleted.
6 Click OK.
If your table has many fields, you may want Excel
to use only one or two of those fields to look for
duplicate records. Rather than deactivating all the
other check boxes manually, first click Unselect
All in the Remove Duplicates dialog box to clear
all the check boxes. You can then click to activate
just the check boxes you want Excel to use.
If you run the Remove Duplicates
command and then decide you did
not want to delete those records
after all, immediately press Ctrl+Z,
or click the Undo icon in the Quick