Another play to get it up ..

With source numbers running in A1 down

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

Put in C1:
=IF(ROWS($1:1)COUNT(B:B),"",SMALL(B:B,ROWS($1:1)) )

Select B1:C1, copy down to cover the max expected extent of source data in
col A. Hide away col B. Col C returns the required results, all neatly
bunched at the top.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
There is a list under column A
30, 45, 25, 30, 46, 45, 25, 99, 1, 1, 88, 99
I would like to sort out all numbers without duplication.
The number will be return under column B in ascending order
1, 25, 30, 45, 46, 88, 99
Does anyone have any suggestions?
Thank for any suggestions
Eric