The attached contains my first look at your problem. The file's a mess and is work in progress. I've used Power Query to try and get the results you want. Although Power Query may not ultimately be used (only used as a cross-check for formula results maybe), I'd like you to check the rankings in columns BK:BL; they're supposed to be how each team was ranked AFTER the game on that date. This will ensure I've understood you correctly and that the results are right
|