Ranking and applying joint ranking

[DanNicholson]

Hello

I am ranking some data using the Multi-Row Formula tool with the below formula:

If [Score] !=[Row-1:% Score] THEN [Row-1:Ranking]+1 ELSE [Row-1:Ranking] ENDIF

My current results are below, and to the right is what I'm after:

i.e. where there is a value that follows a group of scores where the score/ranking is joint, I need it to rank by the position it's in, not following on in rank with just +1.

I hope that makes sense! 

Any ideas?

Thanks

Dan

[IraWatt · Accepted solution]

Hey @DanNicholson,

Here is one way to do this:

Any questions or issues please ask :)
HTH!
Ira

[DanNicholson]

Perfect, thank you so much @IraWatt :)

[IraWatt]

No worries @DanNicholson 😄