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
|
|||
|
|||
problem sorting
I can not get the following to sort correctly,
1 7 3 22 x 8 10 x 17 8 x 11 when I sort these they do as follows 1 3 7 10 x 17 22 x 8 8 x 11 it does fine with the single digits but as soon as there are others it sees the 10 as a 1 and a 0 so it puts this one before the 8. Changing them to text does not help. I believe it is in the format but I can't quite figure it out. Thanks, ty |
#2
|
|||
|
|||
problem sorting
In your list, Excel is interpreting the singles as numbers and the rest as
text. With cells formatted as Text re-enter your list manually then sort (A-Z), I got: 1 10 x 17 22 x 8 3 7 8 x 11 "ty" wrote in message ... I can not get the following to sort correctly, 1 7 3 22 x 8 10 x 17 8 x 11 when I sort these they do as follows 1 3 7 10 x 17 22 x 8 8 x 11 it does fine with the single digits but as soon as there are others it sees the 10 as a 1 and a 0 so it puts this one before the 8. Changing them to text does not help. I believe it is in the format but I can't quite figure it out. Thanks, ty |
#3
|
|||
|
|||
problem sorting
You received a reply to a similar posting earlier today.
Basically you were told to break into two columns and sort on the one with the numbers. .................................................. .. 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 .................................................. ........ Gord Dibben MS Excel MVP On Tue, 16 Jun 2009 13:40:01 -0700, ty wrote: I can not get the following to sort correctly, 1 7 3 22 x 8 10 x 17 8 x 11 when I sort these they do as follows 1 3 7 10 x 17 22 x 8 8 x 11 it does fine with the single digits but as soon as there are others it sees the 10 as a 1 and a 0 so it puts this one before the 8. Changing them to text does not help. I believe it is in the format but I can't quite figure it out. Thanks, ty |
Thread Tools | |
Display Modes | |
|
|