Ranking
Posted by SJC on January 25, 2001 5:38 PM
I have a list of values that I would like to assign ranks among them. For example, in A1:A5 are manually-entered values. In B1:B5, I would like to assign ranks for the values in A1:A5.
I know how to do this by sorting by column A. My question is can the ranking be done without having to sort (including macros to sort)? Is there a formula that can accomplish this task?
Posted by Dave Hawley on January 25, 2001 6:35 PM
Hi SJC
Yes there is and It's called RANK (believe it or not). Here's an example:
=RANK(A1,$A$1:$A$15)
Where A1 is the number to Rank and A1:A15 is the range of numbers to Rank A1 against.
Hope this helps
OzGrid Business Applications
