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.