M
mightyeskimo
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.
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.