Spreadsheet: 882305d1730644416-formula-needed-for-a-competition-1-ranks-scores-2-starts-over-3-does-not-skip-excel-forum-sample-bdmt-scoresheet
Sheet: copy trial

Paste Special Merge - Paste Special | Paste Special - Score | Helper Column | Rank Column | Place | sort to original | Status x = [NAME] = Send O = Order | Score | DIVISION | LEVEL | CATEGORY | EXP. [NAME]. Int. Adv. Pro-Am | Merged Columns | Entry # | J-1 TRAJE | J-1 STAGE | J-1 TECH | J-1  STAGE USE | J-1  GENERAL | JUDGE #1 TOTAL | J-2 TRAJE | J-2 STAGE | J-2 TECH | J-2 STAGE USE | J-2 GENERAL | JUDGE #2 TOTAL | J-3 TRAJE | [NAME] | J-3 TECH | J-3 STAGE USE | J-3 GENERAL | JUDGE #3 TOTAL | SCORE
01-P/NP01-YC01-Solo01-Beg. | 96.5 |  |  | 1 | 1 |  |  | 01-P/NP | 01-YC | 01-Solo | 01-Beg. |  | 40-04 | 20 | 20 | 18 | 18 | 17 |  | 20 | 20 | 20 | 20 | 20
01-P/NP01-YC01-Solo01-Beg. | 92.5 |  |  | 2 | 4 |  |  | 01-P/NP | 01-YC | 01-Solo | 01-Beg. |  | 45-01 | 20 | 16 | 18 | 17 | 18 |  | 20 | 18 | 19 | 20 | 19
01-P/NP01-YC01-Solo01-Beg. | 92 |  |  | 3 | 2 |  |  | 01-P/NP | 01-YC | 01-Solo | 01-Beg. |  | 42-01 | 18 | 15 | 20 | 20 | 18 |  | 18 | 19 | 19 | 19 | 18
01-P/NP01-YC01-Solo01-Beg. | 90 |  |  | 4 | 3 |  |  | 01-P/NP | 01-YC | 01-Solo | 01-Beg. |  | 43-03 | 16 | 17 | 18 | 17 | 18 |  | 17 | 20 | 18 | 20 | 19
01-P/NP01-YC01-Solo02-Int. | 97 |  |  | 1 | 5 |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 09-04 | 20 | 18 | 20 | 20 | 20 |  | 20 | 19 | 19 | 19 | 19
01-P/NP01-YC01-Solo02-Int. | 96 |  |  | 2 | 10 |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 43-07 | 20 | 19 | 20 | 18 | 18 |  | 20 | 19 | 18 | 20 | 20
01-P/NP01-YC01-Solo02-Int. | 95.5 |  |  | 3 | 8 |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 42-03 | 20 | 19 | 19 | 19 | 20 |  | 20 | 18 | 18 | 20 | 18
01-P/NP01-YC01-Solo02-Int. | 95 |  |  | 4 | 9 |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 43-06 | 20 | 18 | 18 | 19 | 19 |  | 20 | 20 | 18 | 20 | 18
01-P/NP01-YC01-Solo02-Int. | 93 |  |  | 5 | 7 |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 34-01 | 20 | 20 | 19 | 17 | 18 |  | 20 | 19 | 17 | 18 | 18
01-P/NP01-YC01-Solo02-Int. | 92.5 |  |  | 6 | 6 |  |  | 01-P/NP | 01-YC | 01-Solo | 02-Int. |  | 19-05 | 20 | 19 | 19 | 19 | 20 |  | 20 | 17 | 18 | 15 | 18
01-P/NP02-CH01-Solo01-Beg. | 100 |  |  | 1 | 20 |  |  | 01-P/NP | 02-CH | 01-Solo | 01-Beg. |  | 45-06 | 20 | 20 | 20 | 20 | 20 |  | 20 | 20 | 20 | 20 | 20
01-P/NP02-CH01-Solo01-Beg. | 98.5 |  |  | 2 | 15 |  |  | 01-P/NP | 02-CH | 01-Solo | 01-Beg. |  | 40-03 | 20 | 20 | 19 | 20 | 19 |  | 20 | 20 | 19 | 20 | 20
01-P/NP02-CH01-Solo01-Beg. | 98 |  |  | 3 | 17 |  |  | 01-P/NP | 02-CH | 01-Solo | 01-Beg. |  | 45-02 | 20 | 20 | 19 | 20 | 19 |  | 20 | 18 | 20 | 20 | 20
01-P/NP02-CH01-Solo01-Beg. | 96 |  |  | 4 | 21 |  |  | 01-P/NP | 02-CH | 01-Solo | 01-Beg. |  | 45-07 | 20 | 19 | 19 | 20 | 19 |  | 20 | 19 | 18 | 20 | 18
01-P/NP02-CH01-Solo01-Beg. | 92 |  |  | 5 | 11 |  |  | 01-P/NP | 02-CH | 01-Solo | 01-Beg. |  | 01-16 | 19 | 18 | 19 | 17 | 19 |  | 20 | 18 | 18 | 18 | 18
01-P/NP02-CH01-Solo01-Beg. | 92 |  |  | 5 | 18 |  |  | 01-P/NP | 02-CH | 01-Solo | 01-Beg. |  | 45-03 | 20 | 16 | 17 | 20 | 19 |  | 20 | 17 | 19 | 18 | 18
01-P/NP02-CH01-Solo01-Beg. | 91.5 |  |  | 6 | 16 |  |  | 01-P/NP | 02-CH | 01-Solo | 01-Beg. |  | 43-08 | 20 | 18 | 16 | 17 | 18 |  | 20 | 18 | 18 | 19 | 19
01-P/NP02-CH01-Solo01-Beg. | 91 |  |  | 7 | 19 |  |  | 01-P/NP | 02-CH | 01-Solo | 01-Beg. |  | 45-05 | 20 | 18 | 19 | 18 | 19 |  | 20 | 15 | 17 | 18 | 18
01-P/NP02-CH01-Solo01-Beg. | 88.5 |  |  | 8 | 12 |  |  | 01-P/NP | 02-CH | 01-Solo | 01-Beg. |  | 14-01 | 20 | 18 | 17 | 19 | 18 |  | 20 | 15 | 15 | 17 | 18
01-P/NP02-CH01-Solo01-Beg. | 88.5 |  |  | 8 | 13 |  |  | 01-P/NP | 02-CH | 01-Solo | 01-Beg. |  | 14-02 | 20 | 16 | 16 | 17 | 17 |  | 19 | 19 | 18 | 18 | 17
01-P/NP02-CH01-Solo01-Beg. | 88.5 |  |  | 8 | 14 |  |  | 01-P/NP | 02-CH | 01-Solo | 01-Beg. |  | 14-03 | 20 | 15 | 15 | 16 | 17 |  | 20 | 18 | 18 | 19 | 19
01-P/NP02-CH01-Solo02-Int. | 97.5 |  |  | 1 | 25 |  |  | 01-P/NP | 02-CH | 01-Solo | 02-Int. |  | 43-09 | 20 | 19 | 20 | 20 | 19 |  | 20 | 20 | 19 | 20 | 18
01-P/NP02-CH01-Solo02-Int. | 94.5 |  |  | 2 | 26 |  |  | 01-P/NP | 02-CH | 01-Solo | 02-Int. |  | 43-10 | 20 | 20 | 19 | 20 | 19 |  | 20 | 17 | 18 | 18 | 18
01-P/NP02-CH01-Solo02-Int. | 94.5 |  |  | 2 | 27 |  |  | 01-P/NP | 02-CH | 01-Solo | 02-Int. |  | 45-19 | 20 | 18 | 17 | 19 | 18 |  | 20 | 19 | 20 | 19 | 19
01-P/NP02-CH01-Solo02-Int. | 94 |  |  | 3 | 24 |  |  | 01-P/NP | 02-CH | 01-Solo | 02-Int. |  | 42-04 | 20 | 16 | 18 | 20 | 18 |  | 20 | 19 | 18 | 20 | 19