Ranking if number is 550
 

I need to know how to rank a list of numbers but only rank the numbers above
550.
Example
A
1523
1242
550
890

I need to rank 1523, 1242, 890, and leave 550 out...
So the ranking should be 1523:3, 1242:2, and 890:1
Thanx.

Ranking if number is 550
 

With your numbers in A1:A4, put this formula in B1 and copy down as far as
B4:
=IF(A1550,RANK(A1,$A$1:$A$4),"")
Is this what you want?

"David A." wrote in message
...
I need to know how to rank a list of numbers but only rank the numbers
above
550.
Example
A
1523
1242
550
890

I need to rank 1523, 1242, 890, and leave 550 out...
So the ranking should be 1523:3, 1242:2, and 890:1
Thanx.

Ranking if number is 550
 

Have you compared your results with the result the OP asked for?
--
David Biddulph

"Stephen" <none wrote in message
...
With your numbers in A1:A4, put this formula in B1 and copy down as far as
B4:
=IF(A1550,RANK(A1,$A$1:$A$4),"")
Is this what you want?

"David A." wrote in message
...
I need to know how to rank a list of numbers but only rank the numbers
above
550.
Example
A
1523
1242
550
890

I need to rank 1523, 1242, 890, and leave 550 out...
So the ranking should be 1523:3, 1242:2, and 890:1
Thanx.

Ranking if number is 550
 

How would it work if I needed the rank in a range of numbers, lets say
between 550 and 855?

"Stephen" wrote:

With your numbers in A1:A4, put this formula in B1 and copy down as far as
B4:
=IF(A1550,RANK(A1,$A$1:$A$4),"")
Is this what you want?

"David A." wrote in message
...
I need to know how to rank a list of numbers but only rank the numbers
above
550.
Example
A
1523
1242
550
890

I need to rank 1523, 1242, 890, and leave 550 out...
So the ranking should be 1523:3, 1242:2, and 890:1
Thanx.