Looks from your example that you want the function in C5 downwards.

With RANK function you use =RANK(number,ref) where number is the specific number you want to rank, in this case D5, and ref is a range of cells within which you want to rank that number, i.e. D5:D157 so in C5 you use

=RANK(D5,D$5:D$157)

Copy this formula down the column.

The $ signs prevent the range from altering as you copy the formula down