Thread: Sort pages?
View Single Post
  #7   Report Post  
Old May 12th 05, 10:12 AM
Posts: n/a

CLR wrote

Use a Helper column with the Name and a suffix of a sequential number,
like Brown,Charlie1 for row one of Charlie Browns data, then
Brown,Charlie2 for his second row, etc etc........then
Armstrong,Jack1....Armstrong,Jack2 for the next group etc
etc...........they don't have to be sorted by name, then sort on this
column and they sort as a group by name, and stay in the proper order
as well

That works, as I was wanting to leave the several rows of data under each
name "connected" to the student. Rather cumbersome to do initial setup
because of that data, though. It's made a little easier by the fact that I
can drag fill sequence for each student, but still....