Formulae for a score chart

  • Thread starter Thread starter Nick H
  • Start date Start date
N

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