Formulae for a score chart

[Nick H]

I'm making a score sheet with results and the total
result, but was wondering how I can make the position
appear under the total (e.g First, second etc), in other
words the formula.
I'm sure there's a way it's just been a long day

Thanks
Nick

 

[Dave R.]

There is rank; for example
+RANK(B1,A1:A25,1)

will show you where the value in B1 stands among values in A1:A25. the final
argument ",1" is optional, but in this case makes it so that the lowest
number has the "best" ranking.