Position in sport results

[91maniek]

Hi!

I am trying to make sport results in Calc. I made collumn with sum of points and now I need to put position in (the most points - 1, next 2 …

Like in Example:

Points Position

1. 27 4
2. 25 5
3. 53 1
4. 45 3
5. 46 2

I need to keep the list sorted by starting numbers.

[JohnSUN]

It seams to me that you are looking a function RANK(). Please try something like as

=RANK(A1;$A$1:$A$5;0)

[91maniek]

Thank you. It is working now!

[mariosv]

Please use comments, when it is not an answer like this one. And if the answer solves your question please tick the .