Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting problem 10 comes before 8
When sorting a list in a column where some are single digits and some are
such as : 1 3 8 8 x 12 10 x 10 they sort as follows 1 3 8 10 x 10 8 x 12 single numbers are fine but once you hit the ones with the x (to show measurements) the 1 in the 10 x 10 comes before the 8. It does not help to make it text. Any thoughts |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting problem 10 comes before 8
You need a helper column. Assuming your list starts in A1, enter this in B1
by using ctrl+shift+enter, then fill down, then sort on column B: =1*LEFT(A1,MATCH(TRUE,ISERROR(1*MID(A1,ROW($1:$10) ,1)),0)-1) Bob Umlas Excel MVP "ty" wrote in message ... When sorting a list in a column where some are single digits and some are such as : 1 3 8 8 x 12 10 x 10 they sort as follows 1 3 8 10 x 10 8 x 12 single numbers are fine but once you hit the ones with the x (to show measurements) the 1 in the 10 x 10 comes before the 8. It does not help to make it text. Any thoughts |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting problem 10 comes before 8
Bob one question, as it is an array formula how can I copy it down?
thanks -- pleae click yes if it was helpfull regards from Brazil Marcelo "Bob Umlas" escreveu: You need a helper column. Assuming your list starts in A1, enter this in B1 by using ctrl+shift+enter, then fill down, then sort on column B: =1*LEFT(A1,MATCH(TRUE,ISERROR(1*MID(A1,ROW($1:$10) ,1)),0)-1) Bob Umlas Excel MVP "ty" wrote in message ... When sorting a list in a column where some are single digits and some are such as : 1 3 8 8 x 12 10 x 10 they sort as follows 1 3 8 10 x 10 8 x 12 single numbers are fine but once you hit the ones with the x (to show measurements) the 1 in the 10 x 10 comes before the 8. It does not help to make it text. Any thoughts |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with sorting | Excel Discussion (Misc queries) | |||
Sorting problem | Excel Discussion (Misc queries) | |||
Not Sorting Problem? | Excel Worksheet Functions | |||
Sorting problem | Excel Discussion (Misc queries) | |||
Sorting problem | Excel Worksheet Functions |