Calculating positions from scores

  • Thread starter Thread starter RP_L2
  • Start date Start date
R

RP_L2

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!
 
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.
 
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
 
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!
Click to expand...

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
 
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!
 
Back
Top