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
|