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)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Team[/TD]
[TD]Division[/TD]
[TD]Div Win %[/TD]
[TD]All Win %[/TD]
[TD]Rank[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1-5A[/TD]
[TD]1.000[/TD]
[TD].750[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1-5A[/TD]
[TD].500[/TD]
[TD].800[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]2-5A[/TD]
[TD].500[/TD]
[TD].500[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]1-5A[/TD]
[TD]1.000[/TD]
[TD].600[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
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)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Team[/TD]
[TD]Division[/TD]
[TD]Div Win %[/TD]
[TD]All Win %[/TD]
[TD]Rank[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1-5A[/TD]
[TD]1.000[/TD]
[TD].750[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1-5A[/TD]
[TD].500[/TD]
[TD].800[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]2-5A[/TD]
[TD].500[/TD]
[TD].500[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]1-5A[/TD]
[TD]1.000[/TD]
[TD].600[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
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.