I'm using Excel to build a league table. There are six teams, who place each other and can score up to 210 points each game. They play five times over the series, total of 1050 points to be won.
As such, the league table is pretty simple and is decided by points scored. If they are level, then points conceded is the second criteria.
Using rank and index, this works fine, except when both teams have scored the same points and conceded the same points. Does anyone know how to have the league table show that Team 2 and Team 3 are both in second place in this situation?