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?
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
Bruce
The older I get, the better I used to be.
USA
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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks