Remove all the duplicates from a list with the click of a button. To remove duplicates;
- Select the list
- Click the Data tab on the Ribbon
- Click the Remove Duplicates button from the Data Tools group
- You are then asked what fields you wish to search for duplicate values in. The default is to search every field
- Click Ok
Check or uncheck the boxes as necessary.
Wham, say goodbye to your duplicates.
A message telling you that Excel has removed x number of duplicate records appears. Please do not fear. If you have made a mistake, just click Undo to see them magically return.
This is a fantastic new hardcore tool for handling duplicate records. Be confident that it does the job you needit to. An alternative method of handling duplicate values is to use the Advanced Filter