Using the =RANK(R5,R$5:R$36)*1

I am using the formula =RANK(R5,R$5:R$36)*1 to sort figures
Column R is a number, and is sorted highest to lowest.
Therefore, the highest number gets 1, lowest gets 32.

Now I have a column that is sorted lowest to highest,
and I need to use the rank formula to assign the lowest
number (1) to the lowest cell rather than the highest.

When I try to do use the above RANK formula, it goes
opposite...assigns the sorted column's highest mark to the
lowest point.

HELP!?! What am I doing wrong?