Ranking if number is >550

[David A.]

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.

 

[Stephen]

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

 

[David Biddulph]

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

 

[David A.]

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