Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I think it's reasonable to want the following items sorted in the following
order: 170B 424 439A 628 731 735 D08 D15 and, in fact, that's how I need them. However, Excel insists on putting them in this order, which is rather scrambled but somewhat logical: 424 628 731 735 170B 439A D08 D15 It appears to be sorting numbers first and then anything that contains an alpha (treating digits as letters). Is there a way to get the first sort order? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Help with sorting | Excel Worksheet Functions | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) |