Hi All,
I have created a band competition recap which list schools and their scores. The groups are entered based on performance time, then ranked within their class. I want to sort the groups by "place" located in column AX. The problem is that I have another row underneath the row with scores that includes rankings (ordinals) for each sub caption listed in the row above. So I need to keep the two rows together for sorting purposes. See truncated sample below.
Row # School Name ....Scores for sub captions ..........................................................Total ......Place (Col AX)
<tbody>
</tbody>
Is that even possible?
Thanks for any suggestions!
I have created a band competition recap which list schools and their scores. The groups are entered based on performance time, then ranked within their class. I want to sort the groups by "place" located in column AX. The problem is that I have another row underneath the row with scores that includes rankings (ordinals) for each sub caption listed in the row above. So I need to keep the two rows together for sorting purposes. See truncated sample below.
Row # School Name ....Scores for sub captions ..........................................................Total ......Place (Col AX)
5 | School 1 | 98 | 88 | 77 | 55 | 66 | 77 | 44 | 88 | 67 | 88 | 67.8 | 3 |
6 | Ordinals | 1 | 2 | 3 | 6 | 5 | 2 | 4 | 1 | 3 | 1 | 3 | |
7 | School 2 | 99 | 92 | 81 | 75 | 71 | 88 | 69 | 90 | 81 | 89 | 83.5 | 2 |
8 | Ordinals | 1 | 1 | 2 | 3 | 3 | 1 | 2 | 1 | 2 | 1 | 2 |
<tbody>
</tbody>
Is that even possible?
Thanks for any suggestions!