picking the higher number

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

Tips and Tricks

Accepted answers

DataNath

@ntudev change the Multi-Row Formula expression to:

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

All comments

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:

Player rank by score.yxmd

BrandonB

Multi-row formula should do the trick

rating.yxmd

binu_acs

@ntudev one way of doing this

Rank_12_07.yxmd

Robin_McIntosh

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

Discussion_Rank.yxmd

Goldrickd

Annotation 2022-07-12 123104.png Annotation 2022-07-12 123127.png

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

@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

Rank_12_07.yxmd

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335