Hello,
I've made a ranking formula that actually works, but I need to have the formula to make blank values to 0 (zero). I have the totals on J5:J33 and the ranking value on K5:K33. Any assistance will be appreciated. thanks. Here is my formula:
=IF((SUM(IF( $J$5:$J$33=J5,1))) =1,(SUM(IF( $J$5:$J$33>=J5,1,0))),( SUM(IF($J$5:$J$33 >=J5,1)))-(( SUM(IF( $J$5:$J$33=J5,1))) -1)*0.5)
Bookmarks