Calculating positions from scores

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RP_L2 - 04 Mar 2008 13:45 GMT

Hi there,

I am trying to set up a spreadsheet to track the scores for our pub quiz
league (!)
I want to be able to input the scores and have a formula return the team's
position in the quiz - eg who was first, second, third etc. I'm sure there is
an easy way of doing this but I can't work it out!

Reply to this Message

RP_L2 - 04 Mar 2008 13:52 GMT

PS - I am doing this for someone who is not particularly computer-literate
hence wanting a formula to do this instead of using a sort then manually
entering the positions - I want to keep it as simple for them to use as
possible.

Reply to this Message

Pete_UK - 04 Mar 2008 14:05 GMT

Put these headings in row 1:

A1: Name
B1: Score
C1: Position

Enter your names and scores in columns A and B, then put this formula in
column C:

=RANK(B2,B$2:B$21)

and copy this down. It doesn't matter if you have less than 20 names, but if
you have more then change the range to suit.

Hope this helps.

Pete

> PS - I am doing this for someone who is not particularly computer-literate
> hence wanting a formula to do this instead of using a sort then manually
> entering the positions - I want to keep it as simple for them to use as
> possible.

Reply to this Message

Ron Rosenfeld - 04 Mar 2008 14:09 GMT

>Hi there,
>
[quoted text clipped - 3 lines]
>position in the quiz - eg who was first, second, third etc. I'm sure there is
>an easy way of doing this but I can't work it out!

Use the RANK worksheet function.

=RANK(team_score,all_scores)

The third, optional argument determines if the highest or lowest score is the
first rank.
--ron

Reply to this Message

RP_L2 - 04 Mar 2008 14:29 GMT

Thanks Pete & Ron, knew there would be a function to do it!
I was trying to think of other words for score or position to put into
search...rank duh!

Reply to this Message