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!