How do I delete duplicate numbers in a column?

[Elliott]

Hi,
I have an Excel column, 55000 rows, of numbers. I would like to delete all duplicates. Is there a command that will do that?
Many Thanks,
Elliott

 

[erik.van.geit]

Hi, Elliott,

take a look at Advanced Filter in the menu Data
there is a setting which allows you to filter/copy unique entries
kind regards,
Erik

 

[Elliott]

Erik, Many thanks, worked liked a champ.

 

[Zack Barresse]

Hi there Elliott,

Have a look here as well ...

http://members.iinet.net.au/~brettdj/

Brettdj's Duplicate Master is a superb add-in which will handle your duplicates in a way that has never been seen in Excel before. It truly is an excellent piece of work.