View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jeffP jeffP is offline
external usenet poster
 
Posts: 38
Default repost: connect two rows of data

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


--
jeffP