How to Remove Duplicates in Excel 2003?
If you are new here, Subscribe to Full Feeds or by Email or follow us in Twitter and receive free daily updates on Office and Windows Tips, Tricks and Tweaks..
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.













[...] Update: How to remove duplicates in Excel 2003? [...]
That’s quite a great. Awesome!
thank you much appreciated – very simple
Thanks for making it so easy.
gr888…!! 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 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
Hmmm…but what about if it’s for a range of more than one column and the only duplication is in, say, column A? Then this doesn’t’ seem to work for me.
nice one. It help me to reduce my overstrain…thnkz buddy
Is there any way to delete duplicated record ( rather strings )?
The above solution didn’t work for set of strings for me. Any suggestions ?