I need a formula or anyway, that can just show me the below. I want to rank the players by the score, so the highest score will always get Rating 1 and so on.
Game | Player | Score | Rating |
1 | Lebron | 78 | 3 |
2 | Lebron | 90 | 1 |
3 | Lebron | 82 | 2 |
1 | Jordan | 90 | 2 |
3 | Jordan | 95 | 1 |
2 | Jordan | 72 | 3 |
Solved! Go to Solution.
Would this be suitable @ntudev? Basically just sorting each player by their score from highest to lowest and then using a grouped ID to assign the rank:
thanks everyone, this is perfect. I just ran into another problem, can we get the rating to also say 1 if the 2 high scores match for the player? like Game 2 and 4 both have 90 points so they should both be Rating 1.
Game | Player | Score | Rating |
1 | Lebron | 78 | 3 |
2 | Lebron | 90 | 1 |
3 | Lebron | 82 | 2 |
4 | Lebron | 90 | 1 |
1 | Jordan | 90 | 2 |
3 | Jordan | 95 | 1 |
2 | Jordan | 72 | 3 |
@ntudev change the Multi-Row Formula expression to:
If [Score]=[Row-1:Score] then [Row-1:Rank] else [Row-1:Rank]+1 endif