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
|