Excel logic

F

fujimi-cho

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

swatsp0p

I believe that, if you don't offer a 2nd sort parameter, the order th
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

HT
 
F

fujimi-cho

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?
 
J

Jerry W. Lewis

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
 
Top