AnsweredAssumed Answered

Ranking records

Question asked by TracyKeenan on Apr 1, 2011
Latest reply on May 17, 2017 by appt


Ranking records


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.