J
jeffP
Hi All,
Here is my dilemma. A is name b:E data, F is sum of each row and every other
row I add the sums is F, so each name has a 2subtotal rows and one grand
total
I need to sort by the grand total but keep the two rows of data together.
Any tricks or tips ? All help is appreciated.
Smith 5 4 5 3 17
6 5 5 4 20 37
Jones 4 3 3 3 13
5 5 5 5 20 33
white 5 4 4 4 17
4 3 3 3 13 30
Pete 5 5 5 5 20
6 5 4 3 18 38
Here is my dilemma. A is name b:E data, F is sum of each row and every other
row I add the sums is F, so each name has a 2subtotal rows and one grand
total
I need to sort by the grand total but keep the two rows of data together.
Any tricks or tips ? All help is appreciated.
Smith 5 4 5 3 17
6 5 5 4 20 37
Jones 4 3 3 3 13
5 5 5 5 20 33
white 5 4 4 4 17
4 3 3 3 13 30
Pete 5 5 5 5 20
6 5 4 3 18 38