One approach using non-array formulae ..

With source numbers running in A1 down

In B1:
=IF(A1="","",IF(COUNTIF(A$1:A1,A1)1,"",A1))

In C1:
=IF(ROW()COUNT(B:B),"",SMALL(B:B,ROW()))
Select B1:C1, copy down to cover the max expected extent of data in col A,
say down to C100. Hide away col B. Col C will return the required ascending
sort of unique numbers from col A.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
Does anyone have any suggestions on how to sort out a list of numbers without
duplication?
For example,
There is a list of numbers under column A
36,6,6,81,9,9,15,17,18,77,55,55
then
sort out those numbers in ascending order
return 6,9,15,17,18,36,55,77 under column B.
Does anyone have any suggestions?
Thank you in advance
Eric