World Cup Group H – Important Note
Ranking of teams in Group stage
This World cup template applies the full Fifa rules per below
(extracted from wikipedia https://en.wikipedia.org/wiki/2018_FIFA_World_Cup#Tiebreakers)
“The group winners and runners-up advance to the round of 16. The ranking of each team in each group will be determined as follows:
1. Points obtained in all group matches;
2. Goal difference in all group matches;
3. Number of goals scored in all group matches;
If two or more teams are equal on the basis of the above three criteria, their rankings will be determined as follows:
4. Points obtained in the group matches between the teams concerned;
5. Goal difference in the group matches between the teams concerned;
6. number of goals scored in the group matches between the teams concerned;”
(7) EXCEL (Smartcoder247 code at this level) – create lookup to a unique reference list (i.e use a simple sequence , Brazil 1, Mexico 2 etc, or FIFA ranking).
this is to enable Excel to complete unique sort and trigger drawing Lots options field
“X. Drawing of lots by the FIFA Organising Committee.” – manually enter order of teams.