Hi Pascal,
The formula works great when teams have played equal number of games every matchday/week. However, when there are less than 10 matches played for whatever reason the positions are calculated wrongly as you can seen in the spreadsheet below for week 24. 'par' v 'udi' is postponed in that particular week and thus teams are ranked from 1 to 18. The expected results are in columns N and O. What do you think is a solution for that little problem?
|