How to sort out a list of numbers without duplication?
 

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

How to sort out a list of numbers without duplication?
 

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

How to sort out a list of numbers without duplication?
 

Hello Eric,

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

Regards,
Bernd

How to sort out a list of numbers without duplication?
 

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 DataFilterAdvanced 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 DataSort (continue with the current selection)
Then select (your list name) - ascending and OK

HTH
Martin



"Eric" wrote in message
...
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

Thank everyone for suggestions
 

Thank everyone for suggestions
Eric

Thank everyone for suggestions
 

welcome ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote in message
...
Thank everyone for suggestions
Eric