[Solved] Ranking Formula
Posted: Sat Aug 11, 2018 10:42 am
Hi - I've been looking at the various formulas for ranking 2 columns with values, but can't seem to find the information that matches my requirements.
I would like to have a final "Ranking" based firstly on games won and secondly on the final score. The "games won" is the first predictor of rank - however, when the same number of games have been won but the "final score" is different (which it will always be), the person with the higher score in that event, is ranked above the other player with the same number of games won.
Games Won Final Score Ranking (done manually)
3 435 6th (each won 3 games, but "final score" of 555 is higher so that score gets the 5th ranking - no tie)
3 555 5th
4 235 4th
1 433 7th
8 654 3rd
9 456 2nd
10 678 1st
Can someone help me with a formula? Many thanks - Jenny
I would like to have a final "Ranking" based firstly on games won and secondly on the final score. The "games won" is the first predictor of rank - however, when the same number of games have been won but the "final score" is different (which it will always be), the person with the higher score in that event, is ranked above the other player with the same number of games won.
Games Won Final Score Ranking (done manually)
3 435 6th (each won 3 games, but "final score" of 555 is higher so that score gets the 5th ranking - no tie)
3 555 5th
4 235 4th
1 433 7th
8 654 3rd
9 456 2nd
10 678 1st
Can someone help me with a formula? Many thanks - Jenny