RANK Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all. I need some help using RANK. I have a column (AG4:AG49) and in
each cell of that column I have a formula (=AVERAGE(AH4:BF4)) that results in
a number between 1 and 50 expressed with 7 decimal places (ex 38.7826087).
The column is then sorted in ascending order by the result of that formula.
In an adjacent column, I would like to assign an integer rank to each number
so I can display the column as 1,2,3,4 etc... instead of 1.4879524,1.4962157,
etc... How would I go about doing this? Thanks.
 
In A1:A8, I have some numbers
In B1 I entered =RANK(A1,$A$1:$A$8)
I copied this down the column
The results are numbers in the range 1 to 8 corresponding to the rang of
each A in the range A1:A8
If I sort A1:A8 (ascending) B1:B8 will show 1,2,3,4,5,6,7,8
best wishes
 
One more question please. This works great but I need the results to be
inversed. The lowest number needs to have the lowest rank rather than the
highest rank. Thanks!
 
Actually, I just answered my own question. I entered a value of 1 for the
Order. Thanks!
 
Back
Top