Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sorting
I am trying to sort the following, but keep getting the wrong answer. I want
A09-2 and A09-3 to be after A09-1, not the way it is shown below. I appreciate any input. I know if I add a 0 in front of the 1, 2, or 3, it will sort okay. However, I prefer to not have to do that. Any help would be much appreciated! A09-1 A09-10 A09-11 A09-12 A09-13 A09-14 A09-15 A09-16 A09-17 A09-18 A09-19 A09-2 A09-20 A09-21 A09-22 A09-23 A09-24 A09-25 A09-26 A09-27 A09-28 A09-29 A09-3 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sorting
I don't know of any way. I would insert a helper column with the formula:
=if(len(a1)=5,left(a1,4)&"0"&right(a1,1),a1) Then sort on that column. You can hide the column if you don't want it displayed. Regards, Fred "RS" wrote in message ... I am trying to sort the following, but keep getting the wrong answer. I want A09-2 and A09-3 to be after A09-1, not the way it is shown below. I appreciate any input. I know if I add a 0 in front of the 1, 2, or 3, it will sort okay. However, I prefer to not have to do that. Any help would be much appreciated! A09-1 A09-10 A09-11 A09-12 A09-13 A09-14 A09-15 A09-16 A09-17 A09-18 A09-19 A09-2 A09-20 A09-21 A09-22 A09-23 A09-24 A09-25 A09-26 A09-27 A09-28 A09-29 A09-3 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sorting
hi,
in a column to the right of your data, enter this..... =MID(A1,5,99) copy the formula down then sort using the helper column as the primary key. after the sort, you can delete the helper column.(or keep it for future sorts if needed.) Regards FSt1 "RS" wrote: I am trying to sort the following, but keep getting the wrong answer. I want A09-2 and A09-3 to be after A09-1, not the way it is shown below. I appreciate any input. I know if I add a 0 in front of the 1, 2, or 3, it will sort okay. However, I prefer to not have to do that. Any help would be much appreciated! A09-1 A09-10 A09-11 A09-12 A09-13 A09-14 A09-15 A09-16 A09-17 A09-18 A09-19 A09-2 A09-20 A09-21 A09-22 A09-23 A09-24 A09-25 A09-26 A09-27 A09-28 A09-29 A09-3 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sorting
It worked perfect! Thank you SO much for your assistance with this! RS
"FSt1" wrote: hi, in a column to the right of your data, enter this..... =MID(A1,5,99) copy the formula down then sort using the helper column as the primary key. after the sort, you can delete the helper column.(or keep it for future sorts if needed.) Regards FSt1 "RS" wrote: I am trying to sort the following, but keep getting the wrong answer. I want A09-2 and A09-3 to be after A09-1, not the way it is shown below. I appreciate any input. I know if I add a 0 in front of the 1, 2, or 3, it will sort okay. However, I prefer to not have to do that. Any help would be much appreciated! A09-1 A09-10 A09-11 A09-12 A09-13 A09-14 A09-15 A09-16 A09-17 A09-18 A09-19 A09-2 A09-20 A09-21 A09-22 A09-23 A09-24 A09-25 A09-26 A09-27 A09-28 A09-29 A09-3 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sorting
This one worked perfect as well! Thank you SO much for your assistance, as
well! Now I have two formulas to use instead of none. Thank you! RS "Fred Smith" wrote: I don't know of any way. I would insert a helper column with the formula: =if(len(a1)=5,left(a1,4)&"0"&right(a1,1),a1) Then sort on that column. You can hide the column if you don't want it displayed. Regards, Fred "RS" wrote in message ... I am trying to sort the following, but keep getting the wrong answer. I want A09-2 and A09-3 to be after A09-1, not the way it is shown below. I appreciate any input. I know if I add a 0 in front of the 1, 2, or 3, it will sort okay. However, I prefer to not have to do that. Any help would be much appreciated! A09-1 A09-10 A09-11 A09-12 A09-13 A09-14 A09-15 A09-16 A09-17 A09-18 A09-19 A09-2 A09-20 A09-21 A09-22 A09-23 A09-24 A09-25 A09-26 A09-27 A09-28 A09-29 A09-3 . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sorting
You're welcome. Thanks for the feedback.
Regards, Fred "RS" wrote in message ... This one worked perfect as well! Thank you SO much for your assistance, as well! Now I have two formulas to use instead of none. Thank you! RS "Fred Smith" wrote: I don't know of any way. I would insert a helper column with the formula: =if(len(a1)=5,left(a1,4)&"0"&right(a1,1),a1) Then sort on that column. You can hide the column if you don't want it displayed. Regards, Fred "RS" wrote in message ... I am trying to sort the following, but keep getting the wrong answer. I want A09-2 and A09-3 to be after A09-1, not the way it is shown below. I appreciate any input. I know if I add a 0 in front of the 1, 2, or 3, it will sort okay. However, I prefer to not have to do that. Any help would be much appreciated! A09-1 A09-10 A09-11 A09-12 A09-13 A09-14 A09-15 A09-16 A09-17 A09-18 A09-19 A09-2 A09-20 A09-21 A09-22 A09-23 A09-24 A09-25 A09-26 A09-27 A09-28 A09-29 A09-3 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting problem 10 comes before 8 | Excel Worksheet Functions | |||
sorting problem | Excel Discussion (Misc queries) | |||
Sorting problem | Excel Discussion (Misc queries) | |||
SORTING PROBLEM | Excel Worksheet Functions | |||
Sorting problem | Excel Discussion (Misc queries) |