If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|