Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
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! |