View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Do a data sort to more levels at once

I don't understand when you say "separate the files".

Simply select your *entire* datalist, then perform a sort on the least
(last) sort key.
Now, just do it (the sort) again, with your 3 remaining sort keys in the
proper order (1st, 2nd, 3rd).

No need to do *anything* between the sorts.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Pam LaDue" wrote
in message ...

Is there a technique or add-on software or utility that will let me do a
Data Sort in excel by 4 or more levels at once. Currently you can only
do 3 levels at once. I'd rather not have to separate the files after
the first sorting operation, in order to sort more types of fields.


--
Pam LaDue
------------------------------------------------------------------------
Pam LaDue's Profile:
http://www.excelforum.com/member.php...o&userid=36773
View this thread: http://www.excelforum.com/showthread...hreadid=564874