I used this, copied down, and it seemed to do just fine?

=RANK(C2,$C$2:$C$8)