I have information for a name that uses three rows. (See below) An average
is created from the values from cells in those three rows. I want to sort by
those averages, but keep the three rows relevant to the name intact. Can
this be done? If so, how?
EX:
1st person 5 4 5 14 12.00
3 3 4 10
3 4 5 12
2nd person 4 4 4 12 11.33
4 5 5 14
4 2 2 8
3rd person 4 5 4 13 14.00
5 5 5 15
4 5 5 14

The averages are the far right number. When sorting, I would like the
highest average listed first and all the information listed in the two rows
under the row containing the average stays with it. What I end up with is

3rd person 4 5 4 13 14.00
1st person 5 4 5 14 12.00
2nd person 4 4 4 12 11.33
3 3 4 10
3 4 5 12
4 5 5 14
Etc.

Thanks,
Jim