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

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

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