=IF(AND(E5<>"", E11<>""), IF(E5>E11, E5, E11), "")
| Cell Range | Content | |------------|---------| | A1 | (Title) | | A3 | Round 1 | | C3 | Quarterfinals | | E3 | Semifinals | | G3 | Final | | I3 | Champion | pool tournament bracket excel
=IF(AND(C5<>"", C8<>""), IF(C5>C8, C5, C8), "") This shows the winner only when both quarterfinalists are known. pool tournament bracket excel
In G5 (Championship):
In the Quarterfinal cell (E5):
R1 QF SF F (1) Player A ──┐ ├───┐ (2) Player B ──┘ │ ├───┐ (3) Player C ──┐ │ │ ├───┘ │ (4) Player D ──┘ │ ├─── Winner (5) Player E ──┐ │ ├───┐ │ (6) Player F ──┘ │ │ ├───┘ (7) Player G ──┐ │ ├───┘ (8) Player H ──┘ | Feature | How to do it | |---------|---------------| | Drop-down player list | Data → Data Validation → List | | Match score input | Use two columns (Player A score, Player B score) | | Automatic winner | =IF(Score1>Score2, Player1, Player2) | | Loser’s bracket | Add columns to the right for consolation matches | | Print bracket | Page Layout → Set Print Area → Fit to 1 page wide | | Protect formulas | Review → Protect Sheet (allow only data entry cells) | 📎 Example Formula for a 4-Player Bracket | | A | B | C | D | E | |---|---|---|---|---|---| | 1 | Semi 1 | Player 1 | Player 2 | Winner | =IF(B1>C1, B1, C1) | | 2 | Semi 2 | Player 3 | Player 4 | Winner | =IF(B2>C2, B2, C2) | | 3 | Final | | | Champion | =IF(D1>D2, D1, D2) | pool tournament bracket excel