|
|
|
|
#1
01-07-2024, 09:54 AM
|
|||
|
|||
I'm not basing it on dates but weeks rather. The reason why the formula fails is because it ranks teams from 1-18 rather than 1-20 when there is A PPD fixture (excluding teams that didn't play from the rankings basically). if two matches are PPD then teams will be ranked 1 to 16.
'base them on scheduled weeks instead, e.g. as number like 202401. When the game was postponed, it will not accounted until it is really played. And then it will be accounted for scheduled week, not for week it was really played at.' Would you elaborate more, please? 
|
|
|
|
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
Hybrid Mode