In each file are 4 groups. If you want to add another group, copy one of the sheets and rename it (For example copy sheet named GroupD and rename it to GroupE). If you want to remove some of the group, just delete the … See more

You have to fill the score of each match and the table will be automatically sorted by number of points. There are no Excel macros, just an array formula and lookup function. The table calculates: GP – Games Played W … See more

You can give a bonus or penalty points to the each team. For example: team2 has 9 bonus points and team4 has 10 penalty points. This will be automatically calculated to the final table. See more

I improved the formula so that it took into account the goal difference. Thanks Bert for inspiration. In the next few days, I will add other versions with a different number of teams. See more