I have searched a ton of posts to find this answer and have not been able to find the scenario that matches mine and works.
I want to sort as follows: (There are 300+ Teams in 35+ Divisions)
<tbody>
</tbody>
Div Win % is the #1 Rank factor, Overall Win % is the tiebreaker. If both are tied, then first match gets the spot.
I will be using this table to index/match the rank to build the standings, so there cannot be any ties.
I want to sort as follows: (There are 300+ Teams in 35+ Divisions)
Team | Division | Div Win % | All Win % | Rank |
A | 1-5A | 1.000 | .750 | 1 |
B | 1-5A | .500 | .800 | 3 |
C | 2-5A | .500 | .500 | 1 |
D | 1-5A | 1.000 | .600 | 2 |
<tbody>
</tbody>
Div Win % is the #1 Rank factor, Overall Win % is the tiebreaker. If both are tied, then first match gets the spot.
I will be using this table to index/match the rank to build the standings, so there cannot be any ties.