ok. don't know why it does show..
but here on my unit the first 15 - 379.73 is ranked 15
and the second one 15 - 330.09 is ranked 16

is this correct

here's the formula.
=IF(($O35=""),"",RANK(O35,O$8:O$82,1)+ SUMPRODUCT((O$8:O$82=O35)*(Q$8:Q$82>Q35))

when i try to integrate column R then its again a tie. don't know why...