Hi Gerryger,

Try this in C2 and filled downward:

=RANK(B2,$B$2:$B$8,1)