Using the =RANK(R5,R$5:R$36)*1
Posted by Knight Coach on January 23, 2002 6:35 AM
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
HELP!?! What am I doing wrong?