remove duplicates in excel 2003?

[issecit]

I used to use to use the 'remove duplicates' option a lot in a more recent version of Excel. Now I'm using the 2003 version and I can't find the option. any suggestions? Many thanks!

[Jakobshavn]

The option is in Advanced Filter

[FDibbins]

i cant remember if 2003 has that option or not. you cant kinda do the same with this tho

copy this down (adjust references as needed)...
=IF(COUNTIF($B$2:$B$14,B2)>1,1,"")
you can then either use filters to just show all the 1's or sort the data based on where that formula is (if needed, in a separate column, put in 1, 2, 3 --> downwards, you can use this to resort back to the original sequence when finished)
then just delete all rows that show 1

[issecit]

Many thanks...sadly all I find there are complicated formulas you need to fill in...no simple options ....I haven't got a clue...thanks anyway..

[issecit]

Ah...I've found it: http://www.lytebyte.com/2008/10/30/h...in-excel-2003/
thanks everyone!