|
Sorting
I am trying to sort alpha-numeric cells all in the same column. But I cannot
get the sort in order. For example; COND7 COND8 COND9 COND10 COND11 COND12 COND13 COND14 COND15 COND16 COND17 COND18 COND109 COND110 COND111 COND112 1SHDAE 151E2 30SHDY 31SHDY Sort Result is not what I would expect 151E2 1SHDAE 30SHDY 31SHDY COND10 COND109 COND11 COND110 COND111 COND112 COND12 COND13 COND14 COND15 COND16 COND17 COND18 COND7 COND8 COND9 |
Sorting
Don't know what you expected - did you look at the "When I sort, I do
not get the results I expect" topic in XL Help? In article , appeng wrote: I am trying to sort alpha-numeric cells all in the same column. But I cannot get the sort in order. For example; COND7 COND8 COND9 COND10 COND11 COND12 COND13 COND14 COND15 COND16 COND17 COND18 COND109 COND110 COND111 COND112 1SHDAE 151E2 30SHDY 31SHDY Sort Result is not what I would expect 151E2 1SHDAE 30SHDY 31SHDY COND10 COND109 COND11 COND110 COND111 COND112 COND12 COND13 COND14 COND15 COND16 COND17 COND18 COND7 COND8 COND9 |
Sorting
I was expeciting at least to see
COND7 COND8 COND9 COND10 COND11 COND12 COND13 COND14 COND15 COND16 COND17 COND18 COND109 COND110 COND111 COND112 "JE McGimpsey" wrote: Don't know what you expected - did you look at the "When I sort, I do not get the results I expect" topic in XL Help? In article , appeng wrote: I am trying to sort alpha-numeric cells all in the same column. But I cannot get the sort in order. For example; COND7 COND8 COND9 COND10 COND11 COND12 COND13 COND14 COND15 COND16 COND17 COND18 COND109 COND110 COND111 COND112 1SHDAE 151E2 30SHDY 31SHDY Sort Result is not what I would expect 151E2 1SHDAE 30SHDY 31SHDY COND10 COND109 COND11 COND110 COND111 COND112 COND12 COND13 COND14 COND15 COND16 COND17 COND18 COND7 COND8 COND9 |
Sorting
Excel is sorting the data in an alpha-numeric order (just like a dictionary
would). And 1's come before 2's. You could either extract the numbers from your data into a different column. And sort your range by these two helper columns (Cond in one column, 7 in the next). Or you could edit your entries: Cond0007 cond0008 cond0009 cond0010 .... To get the sort you want. appeng wrote: I was expeciting at least to see COND7 COND8 COND9 COND10 COND11 COND12 COND13 COND14 COND15 COND16 COND17 COND18 COND109 COND110 COND111 COND112 "JE McGimpsey" wrote: Don't know what you expected - did you look at the "When I sort, I do not get the results I expect" topic in XL Help? In article , appeng wrote: I am trying to sort alpha-numeric cells all in the same column. But I cannot get the sort in order. For example; COND7 COND8 COND9 COND10 COND11 COND12 COND13 COND14 COND15 COND16 COND17 COND18 COND109 COND110 COND111 COND112 1SHDAE 151E2 30SHDY 31SHDY Sort Result is not what I would expect 151E2 1SHDAE 30SHDY 31SHDY COND10 COND109 COND11 COND110 COND111 COND112 COND12 COND13 COND14 COND15 COND16 COND17 COND18 COND7 COND8 COND9 -- Dave Peterson |
Sorting
There is a commercial alternative available: "Special Sort" from yours truly... http://www.realezsites.com/bus/primitivesoftware (you can try it before buying) -- Jim Cone San Francisco, USA "appeng" wrote in message I was expeciting at least to see COND7 COND8 COND9 COND10 COND11 COND12 COND13 COND14 COND15 COND16 COND17 COND18 COND109 COND110 COND111 COND112 |
| All times are GMT +1. The time now is 08:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com