SirScott13
Board Regular
- Joined
- Sep 21, 2012
- Messages
- 63
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet that is compiling the results of 6 different climbing competitions. The climbers can attend all 6 competitions and can score multiple times per competition, but only their top 2 point totals count towards their season rankings. I have a sheet which groups all of the competitions into a sheet and then lists their top 2 scores. At this point, I just want to create a new tab/sheet which ranks the athletes with the sum of their top two climbs. This list would then be ranked from highest point total to lowest.
Here is the Mini-Sheet for the existing data.
Here is the Mini-Sheet for the existing data.
Cell Formulas | ||
---|---|---|
Range | Formula | |
B6:B8,A13:C44,C5:C12,A5:A12 | B6 | ='High Point'!B6 |
A45:C84 | A45 | =Ozark!A5 |
A85:C124 | A85 | ='Upper Limits'!A5 |
A125:C164 | A125 | =RoKC!A5 |
A165:C204 | A165 | ='The Crag'!A5 |
A205:C243,A244:B244 | A205 | ='High Point Cleveland'!A5 |
C244 | C244 | =A14:C244='High Point Cleveland'!C44 |
A247:A253 | A247 | =UNIQUE(FILTER(B5:B244,B5:B244<>0)) |
B247:C253 | B247 | =INDEX(SORT(FILTER($C$2:$C$244,$B$2:$B$244=A247),,-1),{1,2}) |
Dynamic array formulas. |