Hi, I would like to make excel table for ordinary tennis league, but if 2 teams are equal with points than it should take into account their mutual match, so who won the match is higher ranking.
So, I have 12 teams, namely:
Team 1
Team2
Team3
Team4
Team5
Team6
Team7
Team8
Team9
Team10
Team11
After entering the results for each round, let Excel itself sort the Teams in the following order:
a) Team with most points is highest ranking.
b) If 2 teams with the same nr. of points, the head-to-head is then watched and whoever won is higher ranking. If the teams have not yet played each other or have result for draw, then skip to c).
c) If the teams are still the same, then they are judged by goal difference - higher difference is higher ranking.
d) If the teams are still the same, then see who received fewer goals - who received less goals is higher ranking..
e If the teams are still the same, then see who scored more goals - who scored more goals is higher ranking.
f) If the teams are still the same, then they occupy the same ranking place.
Here is link for demo file:
If you have any solution / formula, pls let me know
Regards
So, I have 12 teams, namely:
Team 1
Team2
Team3
Team4
Team5
Team6
Team7
Team8
Team9
Team10
Team11
After entering the results for each round, let Excel itself sort the Teams in the following order:
a) Team with most points is highest ranking.
b) If 2 teams with the same nr. of points, the head-to-head is then watched and whoever won is higher ranking. If the teams have not yet played each other or have result for draw, then skip to c).
c) If the teams are still the same, then they are judged by goal difference - higher difference is higher ranking.
d) If the teams are still the same, then see who received fewer goals - who received less goals is higher ranking..
e If the teams are still the same, then see who scored more goals - who scored more goals is higher ranking.
f) If the teams are still the same, then they occupy the same ranking place.
Here is link for demo file:
PD League-Demo.xlsx
Data Round,Choose,Choose,Combined,#,Team,P,W,D,L,+,-,+/-,P,Team 1. round,TEAM11,TEAM10,0,:,6,0 : 6,1.,TEAM5,6,5,1,0,26,10,16,16,TEAM1 1. round,TEAM6,TEAM1,3,:,3,3 : 3,2.,TEAM10,5,4,0,1,20,10,10,12,TEAM2 1. round,TEAM7,TEAM2,/,:,/,/ : /,3.,TEAM6,6,3,2,1,22,14,8,11,TEAM3 1. round,TEAM3,TEAM9,2,:,4...
docs.google.com
If you have any solution / formula, pls let me know
Regards