Sorting two rows as a group

[Johnmus]

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)

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!

 

[Fluff]

You could use a helper column.
in AY2 put =IF(AX2<>"",AX2,AY1+0.5) & fill down
Then you can sort on column AY

HTH

 

[Johnmus]

That works perfectly! Thanks for the response, it is appreciated.

John

 

[Fluff]

Glad to help & thanks for the feedback

 

[Johnmus]

Noticed that when there is a tie in a class the formula does not work. Anyway around that?

 

[Fluff]

Try
=IF(AX2<>"",AX2,AY1+0.05)+(COUNTIF(AX$2:AX2,AX2)/10)

 

[Johnmus]

Try
=IF(AX2<>"",AX2,AY1+0.05)+(COUNTIF(AX$2:AX2,AX2)/10)

Works great! Thank you!
John

 

[Fluff]

Glad to help & thanks for the feedback