Quote:
Originally Posted by p45cal
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  .
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? |
Actually, there is a way to confirm the start of a fresh round of fixtures. I added the no of games played by the home team and away team in columns E & G. When the number increments in any column, a fresh round of fixtures begins. It doesn't matter if the match numbers are not the same. The highest number of games played confirms which round of fixtures it belongs in.