So we're looking for rankings after each 'round'?
It's clearly not easy to define rounds using dates.
How about ranking each team at the time they've played the same number of games?
In the attached, a graphical way of showing what you might want to call rounds:
In cell BE1 enter a game number, then conditional highlighting will highlight those teams having played that number of games, both in columns BE:BF and columns C:D.
Would it be useful to have a team ranking comparing all teams having played the same number of games?
Enter 36, or 37 or 38 in cell BE1 and you have neat clusters of 12 teams, but enter 35 and you'll still see 12 teams highlighted, but they're not contiguous. Is there, nevertheless, mileage in having rankings in corresponding cells? Clarified perhaps by also showing the count of games played so that people will know whether a team has a game 'in hand' or not next to its ranking?

Attached Files

msofficeforums51391League Standings Sample Sheet02.xlsm (113.8 KB, 3 views)