View Single Post
  #1   Report Post  
Perttu O.
 
Posts: n/a
Default giving points by a result (function)

is there a way to give points by a function ?

and in english, sport results (points) in excel sheet, let's say varying
from 10 to 100 and I would like to give them points from 10 down. meaning
that the best player (biggest points) would get 10 points, next biggest
points would get 9 and so on.

is there a formula or function to make this automatically ?