Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting a sheet
Hello:
I have a problem in sorting a sheet. I choose column A to sort in ascending order, which is does... with 1 problem. Excel usually sorts by the first digit; these spreadsheets are sorting numerically. 333 is being placed before 330A, and 333 is being placed before 1234. and no, it is not a matter of sorting from z-a or a-z. How can I get the sort to like it normally does? Thanks for any help... John |
#2
|
|||
|
|||
Johnny
Excel sorts on the entire number/text, not just the first digit, so it is sorting fine. the only way you can get it sorting by the first digit would be to use a helper column, say SO. In Z2 (Presumes row 1 is headers and that columnar has the data) =LEFT(A2,1) Now sort on the new column SO -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "JohnnyJomp" wrote in message ... Hello: I have a problem in sorting a sheet. I choose column A to sort in ascending order, which is does... with 1 problem. Excel usually sorts by the first digit; these spreadsheets are sorting numerically. 333 is being placed before 330A, and 333 is being placed before 1234. and no, it is not a matter of sorting from z-a or a-z. How can I get the sort to like it normally does? Thanks for any help... John |
#4
|
|||
|
|||
Hi Nick...
By golly, you are right. I was sure that it normally sorted 1000 before 99 and 101A before 102. I am not sure I understand your workaround, but will have a go at it. Thanks John "Nick Hodge" wrote: Johnny Excel sorts on the entire number/text, not just the first digit, so it is sorting fine. the only way you can get it sorting by the first digit would be to use a helper column, say SO. In Z2 (Presumes row 1 is headers and that columnar has the data) =LEFT(A2,1) Now sort on the new column SO -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "JohnnyJomp" wrote in message ... Hello: I have a problem in sorting a sheet. I choose column A to sort in ascending order, which is does... with 1 problem. Excel usually sorts by the first digit; these spreadsheets are sorting numerically. 333 is being placed before 330A, and 333 is being placed before 1234. and no, it is not a matter of sorting from z-a or a-z. How can I get the sort to like it normally does? Thanks for any help... John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |