Spreadsheet: 99469d1298073693-how-to-get-cell-of-max-value-in-range-2011-grand-prix-race-bracket
Sheet: Sheet 1

Winner's Bracket |  |  |  |  |  |  |  |  |  |  | FINAL |  | Loser's Bracket
Round 1 |  |  |  |  | Round 3 |  |  | Round 5 |  |  | Round 7 |  | Round 6 |  |  |  | Round 4 |  |  |  | Round 2
 |  |  |  |  |  |  |  |  |  |  | Round 5 Winner | Round 6 Winner | Round 5 Losers (2 cars) & Round 4 Winners (4 cars) |  |  |  | Round 3 Losers (8 cars) & Round 2 Winners (8 cars) |  |  |  | Round 1 Losers (30 cars)
 | Name | Car # | [NAME] | Place |  | Car # | Place |  | Car # | Place | Car # | Car # | Place | Car # | Heat |  | Place | Car # | Heat |  | Place | Car # | Heat
Heat A | Mackenzie Bartles | 1 | 1 | 3 | Heat V |  |  | Heat AF |  |  |  |  |  |  | AF | Heat AG |  |  | V | Heat Y |  |  | A | Heat M
 | [NAME] | 15 | 2 | 2 |  |  |  |  |  |  |  |  |  |  | Y |  |  |  | M |  |  |  | C
 | [NAME] | 12 | 3 | 1 |  |  |  |  |  |  |  |  |  |  | Z |  |  |  | X |  |  |  | F
 | [NAME] | 4 | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U |  |  |  | J
Heat B | [NAME] | 5 | 1 |  |  |  |  |  |  |  |  |  |  |  | AA | Heat AC |  |  | V | Heat Z |  |  | A | Heat N
 | [NAME] | 6 | 2 |  |  |  |  |  |  |  |  |  |  |  | AB |  |  |  | N |  |  |  | D
 | [NAME] | 7 | 3 |  |  |  |  |  |  |  |  |  |  |  | AF |  |  |  | X |  |  |  | F
 | [NAME] | 24 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W |  |  |  | J
Heat C | [NAME] | 9 | 1 |  |  |  |  |  |  |  | Instructions and Flow of Race |  |  |  |  |  |  |  | V | Heat AA |  |  | A | Heat P
 | [NAME] | 28 | 2 |  |  |  |  |  |  |  | All of the losers in the Winner's Bracket rounds will always |  |  |  |  |  |  |  | P |  |  |  | D
 | [NAME] | 11 | 3 |  |  |  |  |  |  |  | be carried over to the next numbered round in the [NAME]'s |  |  |  |  |  |  |  | W |  |  |  | G
 | [NAME] | 3 | 4 |  |  |  |  |  |  |  | Bracket (ex: Round 3 losers are carried over to Round 4). |  |  |  |  |  |  |  | R |  |  |  | K
Heat D | [NAME] | 13 | 1 |  |  |  |  |  |  |  | In the Loser's Bracket simply fill in a car number from the |  |  |  |  |  |  |  | W | Heat AB |  |  | B | Heat Q
 | [NAME] | 14 | 2 |  |  |  |  |  |  |  | corresponding heat (all heats are uniquely lettered to |  |  |  |  |  |  |  | Q |  |  |  | D
 | Parker Bartles | 2 | 3 |  |  |  |  |  |  |  | reduce confusion - the only duplicated heat letters in the |  |  |  |  |  |  |  | S |  |  |  | G
 | [NAME] | 16 | 4 |  |  |  |  |  |  |  | Loser's Bracket are the losers from the Winner's Bracket). |  |  |  |  |  |  |  | T |  |  |  | K
Heat E | [NAME] | 17 | 1 |  | Heat W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | Heat R
 | Naomi Leedahl | 18 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
 | [NAME] | 46 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G
 | [NAME] | 20 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L
Heat F | [NAME] | 44 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | Heat S
 | [NAME] Juetten | 22 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
 | McKenzy DeGidio | 23 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 | [NAME] | 8 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L
Heat G | Mariah [NAME] | 25 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | Heat T
 | [NAME] | 26 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
 | [NAME] | 27 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 | Mya Lent | 10 | 4
Heat H | [NAME] | 29 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | Heat U
 | [NAME] | 30 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
 | Micalyn Andreas | 33 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 | [NAME] | 34 | 4
Heat J | [NAME] | 35 | 1 |  | Heat X
 | [NAME] | 36 | 2
 | [NAME] | 37 | 3
 |  |  | 4
Heat K | [NAME] | 40 | 1
 | [NAME] | 41 | 2
 | [NAME] | 21 | 3
 |  |  | 4
Heat L | [NAME] | 45 | 1
 | Christain Leedahl | 19 | 2
 | [NAME] | 39 | 3
 |  |  | 4