Thanks for the reply.
Basically the ranks are decided as follows:
Total number of wins
Number of wins in matches between the teams
Point differential in matches between the teams
Overall point differential
Points scored
Points scored away from home
At the moment, the tiebreakers are all set up in individual columns (on the dummy standings sheet) starting with wins.
I use a sumproduct formula to find how many rows have an equal value in the wins column AND a superior value in the head to head column
For example, if the wins rank is in column A, and the head to head point differential is in column B:
This works perfectly for seperating two teams based on head to head results, however, the situation I seem to get a problem in, is when there is a tiebreaker between three or more teams, and they havent all played each other.
When that happens, the formula above will rank a team who has played no matches against the other tied teams the same as it would a team which has drawn all its games.
Bookmarks