I believe that, if you don't offer a 2nd sort parameter, the order the
items appear within the grouping of the first sort remain unchanged

That is to say that if Group 1 has members in this order:

Smith
Jones
Lee
Albertson

once sorted by Group 1, the order of the names will be as above.

You can, however, use a 2nd criteria to further sort within Groups,
either Ascending or Descending to return:

Albertson
Jones
Lee
Smith

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473023