Multiple Sorts

[Nigel]

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

 

[Tom Ogilvy]

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.

 

[Nigel]

Thanks Tom, I will try it.

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

if