How to do it?

To remove duplicate records in Excel do the following:

1. Select the column title that has duplicate records
2. Click Data menu and point to Filter, and then click Advanced Filter
3. Under Action, click Copy to another location
4. Select the starting location where you want to copy all the unique records by clicking on a cell
5. Click to select the Unique records only check box
6. Click OK.

You should have all duplicates removed in this new location.