Excel logic
 

Can someone answer this question?
I have 4 groups, let's call them Group A,B,C & D, and each group has
numerous members. All the participants are listed by name &
group,followed by several columns of data. Sorting by group designation
is easy enough, but what logic does Excel use to determine who is listed
first in each group?


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

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

SwatspOp,
Thanks for the information; just so I understand you correctly: If the
first entry for group C happens to be number 47 on my list, it will be
listed first when I sort by group designation, right?


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

Yes, Excel uses a "stable" sort algorithm, meaning that it does not
change the order of any records other than what is required by the sort
fields. This allows you to potentially sort on more than three fields
by doing multiple sorts.

Jerry

fujimi-cho wrote:

SwatspOp,
Thanks for the information; just so I understand you correctly: If the
first entry for group C happens to be number 47 on my list, it will be
listed first when I sort by group designation, right?