Microsoft Excel Tutorial: Tiebreakers in Leagues Cup Soccer Group Stage.

Lionel Messi’s debut in the US for Miami is in the Leagues Cup. This four-week tournament includes 47 clubs from across the USA, Canada, and Mexico. What are the odds of a tiebreaker in group play for the Leagues Cup? If Miami finishes first or second in their group, who will they play in the knockout stage?

To download this workbook: https://www.mrexcel.com/youtube/M6xbdRFASnI/

Table of Contents
(0:00) Problem Statement: Odds of tiebreaker
(0:21) Orlando City Soccer two home matches in Leagues Cup
(0:48) Lionel Messi’s US debut will be in Leagues Cup
(1:00) Leagues Cup Overview
(1:26) Orlando City in South Group 2
(1:40) 2 Automatic Berths in knockout round
(2:00) Who would play Messi in Knockout round?
(2:22) Scenarios in Group Play
(2:57) Group Play Draw
(3:15) 64 Scenarios
(3:30) SEQUENCE in Excel
(3:45) BASE function in Excel
(4:15) SWITCH function in Excel
(4:37) Ranking with LARGE function in Excel
(4:50) CONCAT function in Excel
(5:00) Checking for Ties
(5:16) 25% chance of a tie in Leagues Cup Group Play
(6:22) Tiebreakers in Leagues Cup Group Play
(7:15) Six possible teams to play Messi in knockout round
(7:40) Wrap-up