View Single Post
  #7   Report Post  
Max
 
Posts: n/a
Default Points Ranking Formulas

Oops, forgot Sheet2 was renamed as: Point n Bonus Structure

Lines:

Name Refers To
--------------------
Bonus =Sheet2!$C$2:$C$17
Points =Sheet2!$B$2:$B$17


should read as:

Name Refers To
---------------------
Bonus ='Point n Bonus Structure'!$C$2:$C$17
Points ='Point n Bonus Structure'!$B$2:$B$17
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--