sorting
I have a sheet with cells a1 to r1 with 6 rows grouping and I have some 30
groups or records. Each group has a total value.
I need to keep the groups together while sorting on the total which is in
column R (Cummulative Total).
example: (some things deleted)
Hitting Fielding Total Cumulative Total
Mechanics 4 Mechanics 4 5
Bat speed 5 ball transfer 5 10
15
this goes on for some 30 records.
How can I keep the groups together while sorting on the Cumulative Total?
|