HOW DO I SORT A COLUMN OF NUMBERS AND HAVE THE DUPLICATES REMOVED

A

Andy Wiggins

1) Use Data > Filter > Advanced Filter to extract the "Unique Records Only"
to another place
2) In the other place, sort the result
3) Please DON'T SHOUT ;-)
 
P

Peo Sjoblom

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)
 
Top