That winner is then referenced in the next match cell using direct cell linking: e.g., WB Round 2, Match C1 (winner of A1 vs winner of A2): =G2 in the “Team 1” slot. Losers of WB Round 1 go to LB Round 1. Losers of WB Round 2 go to LB Round 2, etc.
Example macro snippet (VBA) to clear scores: That winner is then referenced in the next
And if you really meant the topic instead, let me know and I’ll write that deep feature separately. Example macro snippet (VBA) to clear scores: And
: In LB Round 1, reference losers from WB Round 1 matches: =IF(C2<E2, B2, D2) → that’s the loser. since that’s a specific
Sub ClearBracket() Range("C2:C100,E2:E100").ClearContents End Sub | Match ID | Team A | Score | Team B | Score | Winner | Next Match | |----------|--------|-------|--------|-------|--------|-------------| | WB R1 M1 | Team 1 | 3 | Team 8 | 1 | Team 1 | WB R2 M1 | | WB R1 M2 | Team 4 | 2 | Team 5 | 0 | Team 4 | WB R2 M1 | | WB R2 M1 | Team 1 | | Team 4 | | | WB Finals |
I’ll assume you want a (double elimination bracket for 8 teams in Excel), since that’s a specific, technical, and actionable request.