Tournament standings for foosball groups
Ereudet
Posted messages
24
Status
Member
-
Ereudet Posted messages 24 Status Member -
Ereudet Posted messages 24 Status Member -
Hello,
I made an Excel file for a tournament, I have 3 groups of 3 teams, and I would like to find a formula to rank the teams in each group from first to third, first based on the number of matches won, then based on the number of goals if there is a tie. I managed to create a table that summarizes, for each team, the number of matches played, won, lost, and the number of goals scored, but I can't find the formula to rank them.
I would like to share my Excel file with you to make it easier, but I don't know how to do that, is it possible?
Thank you in advance,
Configuration: Windows / Chrome 68.0.3440.106
I made an Excel file for a tournament, I have 3 groups of 3 teams, and I would like to find a formula to rank the teams in each group from first to third, first based on the number of matches won, then based on the number of goals if there is a tie. I managed to create a table that summarizes, for each team, the number of matches played, won, lost, and the number of goals scored, but I can't find the formula to rank them.
I would like to share my Excel file with you to make it easier, but I don't know how to do that, is it possible?
Thank you in advance,
Configuration: Windows / Chrome 68.0.3440.106
2 answers
-
to attach your file
1) Go to https://www.cjoint.com/
2) Click on [Browse] to select your file (max 15 MB)
3) Scroll down and click on the blue button [Create Cjoint link]
4) After a few seconds, the second page appears, with the link in bold; right-click on it and choose "Copy link"
5) Return to your discussion on CCM, and in your message, select "Paste".
=>See the guide https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers