Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating positions from scores
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating positions from scores
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating positions from scores
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 "RP_L2" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating positions from scores
On Tue, 4 Mar 2008 05:45:00 -0800, RP_L2
wrote: 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! 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating positions from scores
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
1st and 2nd.... positions | Excel Discussion (Misc queries) | |||
excel golf scores, how do I add the scores for all par 3's etc | Excel Worksheet Functions | |||
Lon Lat positions in chart | Charts and Charting in Excel | |||
Calculating Percentiles of Test Scores? | Excel Discussion (Misc queries) | |||
Calculating average scores from multiple sheets' information | Excel Worksheet Functions |