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

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

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

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"JEFF" wrote in message
...

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

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
...