Help With Formulas Please - Time and points raking system

[SJB777]

Hi, please see attached sheet and comments added to cells for required formulas. Any help much appreciated.

Many Thanks

Steve

[Pauleyb]

In 2010, MS improved the RANK function. You now have RANK.EQ and RANK.AVG. Determine which technique you prefer.

In cell B1 you wrote:

Is there a formula which will copy names of schools when entered in "Times" sheet?

The easy answer is to just use =Times!B1 and then drag that formula to the right. To have it truly dynamic would require some advanced techniques.

In B2 you comment:

= Points total according to time in row 2 "Times".
Quickest time = Highest points
So if there are 20 schools competing quickest time = 20 points, Slowest time = 1 point
If no time entered points = 0 points not "error"

Try this formula in B2, then drag down and across to fill your matrix.
=IF(ISBLANK(Times!B2),0,RANK.EQ(Times!B2,Times!$B2:$U2,0))

I used RANK.EQ, use RANK.AVG if you wish.

Looks like you have the idea for Total Points, and then the final rank would again use the RANK.xxx formula.

[SJB777]

Many thanks Pauleyb however when entering the formula to calculate points "=IF(ISBLANK(Times!B2),0,RANK.EQ(Times!B2,Times!$B2:$U2,0))" I get the error:

#NAME?

What do i need to do to correct this?

Many thanks

[Pauleyb]

You do have 2010, correct? Try changing the RANK.EQ to just RANK.