Thread: Multiple Sorts
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default 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