Thread: Sort pages?
View Single Post
  #9   Report Post  
Old May 12th 05, 11:28 AM
CLR
 
Posts: n/a
Default

Followup on your followup <g
Although the concatenated suffix's must be in sequence for each group, they
need NOT start with 1 each time..........sooo, you could just use another
helper column with numbers sequenced from 1-XXXX, and then concatenate the
names and the respective row from this new column, so it might read,
Brown,Charlie1....Brown,Charlie2......Armstrong,Ja ck12......Armstrong,Jack13
, etc etc..........would make the initial setup easier, just type in one
formula and copy down................



Vaya con Dios,
Chuck, CABGx3


"David" wrote in message
...
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..........


Followup on initial setup: If I used formulas in helper column for the
first student like =A2&1, =A2&2, =A2&3, etc., where A2 held the first
student's name, selected those and drag-filled down, it took most of the
pain out.

--
David