Populating the columns could be speeded up of course using CONCATENATION and
copy-down, and the sequential suffix need not re-start with 1 or 101 each
time, the only requirement is that each successive line is higher than the
previous line....."SmithJoe101 for the first row and SmithJoe102 for the
second row, etc etc.......then DoeJohn87105, DoeJohn87106, etc etc will work
just as well............the number only comes into play after the
alphabetical sorting of the name..

Vaya con Dios,
Chuck, CABGx3



"Stephanie" wrote:

That would help, however I have about 90 pages/10 people per page/ to do
that! That would take forever, but thank you for the idea!

"CLR" wrote:

I do this sort of thing with a helper column, insert "SmithJoe101 for the
first row and SmithJoe102 for the second row, etc etc.......then DoeJohn101,
DoeJohn102, etc etc...........then sort on that column

Vaya con Dios,
Chuck, CABGx3



"Stephanie" wrote:

I am looking for a way to be able to group data on subsequent rows together
and then sort those groups into a list. My data looks something like this:

(Column 1) (2) (3) (4) (5)
Smith, Joe 1 2 3 A
5 6 B

Doe, John 1 2 3 A
5 6 B

Doe, Jane 1 2 3 B
6 5 A
7 8 9

I need to be able to group each "person" in column 1 together with the data
in the next 4 columns and following rows. Then I need to sort the groups so
that every "person" with a "3" in the 4th column together. See what I mean?
Can I do this and if I can, how?
Thanks!