Windows Forum

Ask something
Discussion Locked

Working out positions from total points?

0 helpful
1 reply

by kaarthuul

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In my Excel spreadsheet:
Column A has the persons name.
Column B has their total points scored.
I need column C to show their overall position.
ie
Mary 126 1
Dave 111 3
Bill 105 4
Lisa 119 2
Is there a function to do this or do I need a formula? Thanks.

1 reply

by wcp

You may use a function RANK.
This assumes you know what your total list is. Let?s say you have a total of 50.
Highlight C1 and enter the following.
=RANK(B1,$B$1:$B$50,0)
Copy C1 and paste to the rest.

This discussion is closed to new replies.