### Title

Ranking records

### Post

I am trying to find a function that will allow me to rank records (tennis players) according to their total points. The trick is, when there are two players with the same total of points, they share the ranking. The person's rank following a shared rank skips by the number of people with the shared rank.

For example:

Name Total Points Rank

Scott 1860 1

Tony 1650 2

Brent 1650 2

Sam 1500 4

Is there a function that can do this skipping calculation?

Thanks for your help.

Tracy

It means I left out some parenthesis when I typed this in.

PrevRank and PrevScore are temporary values that exist only within this calculation.

Let ( [ PrevRank = GetNthRecord ( Rank ; If ( Get ( RecordNumber ) = 1 ; 0 ; Get ( RecordNumber ) - 1 )

);PrevScore = GetNthRecord (

TotalPoints; If ( Get ( RecordNumber ) = 1 ; 0 ; Get ( RecordNumber ) - 1 ))] ;If ( PrevScore ≠ TotalPoints ; Get ( RecordNumber ) ; PrevRank )

)