First select the numbers plus a header on top, anything with text will do,
then do advanced filter, select copy to another location and unique records
only, select where to copy it and click OK Now you can sort the list and
copy and paste it where you want

Next version of Excel (2007) will have a function called Remove Duplicates
that will do this on the fly

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)


"JEFF" wrote in message
...