Hi,

You can try
=RANK(C2,$C$2:$C$6,1)
HTH