Long back I wrote an article on how to remove or highlight duplicates in Excel 2007? Though this option is much visible in Excel 2007, it is also possible in Excel 2003 with simple steps which are hidden inside. Also many have been looking for this option in Office 2003.
So, how to remove duplicates in Excel 2003?
Select the row or column that has duplicates that you would like to remove.
Go to Data -> Filter -> Advanced Filter.
Make sure the range is correct and check the option “unique records only“.
You can either choose to replace the content or copy unique records to a new location.