How to remove duplicate records in Excel
To remove duplicate records in Excel do the following:
- Select the column title that has duplicate records
- Click Data menu and point to Filter, and then click Advanced Filter
- Under Action, click Copy to another location
- Select the starting location where you want to copy all the unique records by clicking on a cell
- Click to select the Unique records only check box
- Click OK.
You should have all duplicates removed in this new location.
Filed in Microsoft Office