Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Sorts
Hi All
I have a worksheet with potentially 6 levels of sortation required. The standard sort allows for three separate keys. What is the best method to create more than three keys? Option 1: conduct mutliple sorts - but I am not sure this is reliable, if it will work at all Option 2: Create composite keys and sort on these, I thikn this will work but the overhead of key creation is not desireable Option 3: something else ?? TIA Cheers Nigel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Sorts
Excel does a persistent sort, so you can sort multiple times on progressive
keys (going from least significant to most significant) and achieve the results you want. So option 1 is the correct approach and will work. -- Regards, Tom Ogivy "Nigel" wrote in message ... Hi All I have a worksheet with potentially 6 levels of sortation required. The standard sort allows for three separate keys. What is the best method to create more than three keys? Option 1: conduct mutliple sorts - but I am not sure this is reliable, if it will work at all Option 2: Create composite keys and sort on these, I thikn this will work but the overhead of key creation is not desireable Option 3: something else ?? TIA Cheers Nigel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Sorts
Thanks Tom, I will try it.
"Tom Ogilvy" wrote in message ... Excel does a persistent sort, so you can sort multiple times on progressive keys (going from least significant to most significant) and achieve the results you want. So option 1 is the correct approach and will work. -- Regards, Tom Ogivy "Nigel" wrote in message ... Hi All I have a worksheet with potentially 6 levels of sortation required. The standard sort allows for three separate keys. What is the best method to create more than three keys? Option 1: conduct mutliple sorts - but I am not sure this is reliable, if it will work at all Option 2: Create composite keys and sort on these, I thikn this will work but the overhead of key creation is not desireable Option 3: something else ?? TIA Cheers Nigel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorts | Excel Worksheet Functions | |||
same range, multiple sheets, different sorts, help please! | Excel Worksheet Functions | |||
Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
Multiple Sorts | Excel Programming | |||
Macro for Multiple Sorts | Excel Programming |