I would like to do, for lack of better description, a double sort on two set of numbers, based on a 3rd (variable) number.
Score 41 45 52 45 38 52 47 35 42 34
Names Adam Danille Davy Dori Bill Mom Randy Angi Shane
# Wins 11 10 10 9 10 10 10 11 9
I would like it to sort by number of wins, then, closest, but not over the score, then over the score. Then, go to the next highest number of wins and do the same thing again. To show 1st, 2nd and 3rd place.
To look like this:
Angi Adam Randy
11 11 10
1 2 3
Score 41 45 52 45 38 52 47 35 42 34
Names Adam Danille Davy Dori Bill Mom Randy Angi Shane
# Wins 11 10 10 9 10 10 10 11 9
I would like it to sort by number of wins, then, closest, but not over the score, then over the score. Then, go to the next highest number of wins and do the same thing again. To show 1st, 2nd and 3rd place.
To look like this:
Angi Adam Randy
11 11 10
1 2 3