How to Remove Duplicates in Excel 2003?
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.
Enjoyed this post? We write daily tips, tricks and tweaks for Office Excel, Word, Powerpoint, Outlook, Windows and other applications. Get 100% free daily updates on 
[...] Update: How to remove duplicates in Excel 2003? [...]
That’s quite a great hack. Awesome!
thank you much appreciated - very simple
Thanks for making it so easy.
gr888 hack…!! too gud…toooooo gud…take it and goo…..
Don’t work here….
Do you need a certain amount of values.. ie
less than 500 cells??
WOW great hack thanks for this
but what about many row duplicated with only a cell value?
Awesome….thanks
really appreciated that!!
how to display some record with same data or double data when we query data from others in excel