| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I sort a list a1 to a15, b1 to b15 etc
I need to sort a worksheet that has a column with a1 to a15 but normal sort
results in a1,a10,a11 not a1,a2 etc that I need |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I sort a list a1 to a15, b1 to b15 etc
Change the cells to a01, a02... etc if possible.
-- Ian -- "raypen" wrote in message ... I need to sort a worksheet that has a column with a1 to a15 but normal sort results in a1,a10,a11 not a1,a2 etc that I need |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I sort a list a1 to a15, b1 to b15 etc
Raypen
Two things 1) Use a helper columns and separate the parts of the data and sort by these helper columns. In your example =Left(A1,1) =Right(A1,1) 2) Set up a custom list. ToolsOptionsCustom Lists and either type them in the order you want or import them from the sheet. Now go to DataSort...Optionsfirst key sort order and select your list -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "raypen" wrote in message ... I need to sort a worksheet that has a column with a1 to a15 but normal sort results in a1,a10,a11 not a1,a2 etc that I need |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I sort a list, How can I keep blank rows between the fields? | Excel Discussion (Misc queries) | |||
| When I sort a list, How can I keep blank rows between the fields? | Excel Discussion (Misc queries) | |||
| Sort a list with uneven row information | Excel Worksheet Functions | |||
| Sort with a List | Excel Worksheet Functions | |||
| How do I sort a list of dates in Excel by month and day? | Excel Discussion (Misc queries) | |||
Linear Mode
