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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mightyeskimo" wrote in message
...
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.

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!

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mightyeskimo" wrote in message
...
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.

Actually, I just answered my own question. I entered a value of 1 for the
Order. Thanks!

"mightyeskimo" wrote:

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!

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mightyeskimo" wrote in message
...
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.