|
|
#30
01-06-2024, 05:57 PM
|
|||
|
|||
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cross-reference with full context a numbered list inside another multilevel list (list style) | MatLcq | Word | 0 | 02-01-2021 06:00 AM |
 Calculate a Date
|
shawn.low@cox.net | Mail Merge | 5 | 12-12-2019 03:22 PM |
| are there any good free golf league programs out there | kener40 | Other Software | 0 | 03-28-2014 05:54 PM |
| calculate age | userman | Excel | 8 | 06-02-2012 10:59 PM |
| Calculate formula base of list menu | rkeles | Excel | 4 | 09-22-2010 12:38 AM |
Windows 11 
Office 2016
Threaded Mode