How to sort out a list of numbers without duplication?

[Guest]

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

 

[Guest]

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.

 

[Bernd]

Hello Eric,

http://www.sulprobil.com/html/listfreq.html

Regards,
Bernd

 

[MartinW]

Hi Eric,

Perhaps this may help,

Insert a row above your data.
Give your list a name in A1 like 'List 1' or whatever.
Select A1 and goto Data>Filter>Advanced Filter.
Check 'Copy to another location'
In the Copy to box put $B$1
Check 'Unique Records Only'
And OK out
Then select from B2 down to the end of your data.
And goto Data>Sort (continue with the current selection)
Then select (your list name) - ascending and OK

HTH
Martin

 

[Guest]

Thank everyone for suggestions
Eric

 

[Max]

welcome ..