View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Not too bright Not too bright is offline
external usenet poster
 
Posts: 1
Default posting points relating to rank

I am trying to allocate points related to finishing position.
I have used "RANK" to determine finishing position.
Example:
IF D1=1 then D2=25
IF D1=2 then D2=20
IF D1=3 then D2=17
IF D1=4 then D2=15
etc. down to position 20 approx