im looking a formula

i have in column a, a list of numbers goig down, none are repeated but
there are blanks in between some cells. i would like to list these
number in column b in ascending order with no spaces.

can you help ?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=467250