example.xls

Hi all

If I have same value couple of times, I don't want it to show as they are in the same rank but would like it to show consecutive numbers.
I am using =RANK(B53,$B$2:$B$64)+COUNTIF($B$2:B53,B53)-1 and works most of the time but if you look at the attached excel worksheet, excel does not like the values in row 2 and 37. It jumps from rank 13 to 15. Can anyone help with this?