Can I use RANK formula to calculate points?

I have a worksheet where I have calculated placings from 1st to 49th (this number will change on each worksheet – sometimes more, sometimes less). I don’t know how to create a formula in the next column to help me calculate points. My point system is ONLY for the top 24 placings and goes backwards from 24 to 1. IE: 1st place receives 24 points down to 24th place receiving 1 point. ALSO, I would like to use this formula on numerous worksheets and total the points that people in the top 24 have. Any help greatly appreciated. Thanks!!

By: Shel

Leave a Reply

Your email address will not be published. Required fields are marked *