OUR GOVERNING BODY
You can use simple IF formulas to automate the bracket so you only have to type the score, and the winner moves automatically.
Assuming Team 1 plays Team 2 in Game 1, the formula will return "Winner" if both teams have played. 18 team double elimination bracket excel
In Column D, use the following formula to determine the loser of each game: You can use simple IF formulas to automate
| Match ID | Round | Bracket | Team A | Team B | Winner | Next Match ID | |----------|--------------|-----------|--------------|--------------|--------|----------------| | 1 | WB R1 | Winners | Team 1 | Team 2 | | 8 | | 2 | WB R1 | Winners | Team 3 | Team 4 | | 8 | | 3 | WB R1 | Winners | Team 5 | Team 6 | | 9 | | 4 | WB R1 | Winners | Team 7 | Team 8 | | 9 | | 5 | WB R1 | Winners | Team 9 | Team 10 | | 10 | | 6 | WB R1 | Winners | Team 11 | Team 12 | | 10 | | 7 | WB R1 | Winners | Team 13 | Team 14 | | 11 | | 8 | WB R2 | Winners | W-M1 | W-M2 | | 14 | | 9 | WB R2 | Winners | W-M3 | W-M4 | | 14 | | 10 | WB R2 | Winners | W-M5 | W-M6 | | 15 | | 11 | WB R2 | Winners | W-M7 | Team 15 | | 15 | | 12 | WB R2 | Winners | Team 16 | Team 17 | | 16 | | 13 | WB R3 (bye) | Winners | Team 18 | - | Team 18 | 16 | | 14 | WB QF | Winners | W-M8 | W-M9 | | 17 | | 15 | WB QF | Winners | W-M10 | W-M11 | | 17 | | 16 | WB QF | Winners | W-M12 | Team 18 | | 18 | | 17 | WB SF | Winners | W-M14 | W-M15 | | 19 | | 18 | WB F (upper) | Winners | W-M16 | - | | 20 (WB Final) | | 19 | WB Final | Winners | W-M17 | W-M18 | | 21 (Grand Final)| Enter the 18 team names in Column B, starting from row 2
For winner cells: =NOT(ISBLANK(Winner)) → gold fill.
Enter the 18 team names in Column B, starting from row 2. Also, enter the corresponding team numbers in Column A.