How to Delete Duplicates in Excel 2003

There are many articles published around Google ”How to Delete Duplicates in Excel 2007 and 2010” so many people still using excel 2003 and there is no option to delete duplicates in excel 2003. There is a simple way we can copy, replace or delete duplicates entry in excel 2003. 

So, How to Delete or Remove duplicates in Excel 2003? 

Open an excel file and select data column or raw

Then go to Data, select filter and click on Advanced Filter

Pop up window will appear “Advanced Filter”

Click on “Unique records only” and press OK

You will see final result. All duplicates will delete.

Please don’t forget to add comment below if you like my post.