Sloth Wrote:
This is an exert from the help on sorting lists with more than 3
columns.
Basically, you need to sort the list twice. If you are sorting based
on A,
then B, then C, then D, then E, then F, you need to first sort by D,
then E,
then F (at the same time, and in that order); and then sort a second
time by
A, then B, then C.

"If you need to sort by more than three columns, sort by the least
important
columns first. For example, if your list contains employee information
and
you need to organize it by Department, Title, Last Name, and First
Name, sort
the list twice. First, click First Name in the Sort by box and sort the
list.
Second, click Department in the Sort by box, click Title in the first
Then by
box, and click Last Name in the second Then by box, and sort the
list."


Thank you Sloth. I believe it worked. Maybe I should use F1 more
often:(


--
JMax
------------------------------------------------------------------------
JMax's Profile: http://www.excelforum.com/member.php...fo&userid=6305
View this thread: http://www.excelforum.com/showthread...hreadid=494208