Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort out a list of numbers without duplication?
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thank everyone for suggestions
Thank everyone for suggestions
Eric |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thank everyone for suggestions
welcome ..
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Eric" wrote in message ... Thank everyone for suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Eliminate List Duplication | Excel Discussion (Misc queries) | |||
List out the Duplication data in another worksheet | Excel Discussion (Misc queries) | |||
How do I sort randomly a list of 22 numbers | Excel Discussion (Misc queries) | |||
How do I prevent duplication of numbers in a column | Excel Discussion (Misc queries) | |||
Remove Duplication from Validation List? | Excel Discussion (Misc queries) |