picking the higher number

[ntudev]

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

[DataNath]

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:

[BrandonB]

Multi-row formula should do the trick

[binu_acs]

@ntudev one way of doing this

[Robin_McIntosh]

Depending on how you want to group, just change the sorting and/or multi-row group.

[Goldrickd]

[ntudev]

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

[DataNath · Accepted solution]

@ntudev change the Multi-Row Formula expression to:

If [Score]=[Row-1:Score] then [Row-1:Rank] else [Row-1:Rank]+1 endif

[binu_acs]

@ntudev