Ranking if number is >550

  • Thread starter Thread starter David A.
  • Start date Start date
D

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.
 
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?
 
How would it work if I needed the rank in a range of numbers, lets say
between 550 and 855?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ranking if number is between 550 and 855. 2
Ranking with Duplicates 1
Rank Formula 1
Ranking Q 1
min if horizontal 0
RANK - Remove repeated ranks for sorting 9
Duplicate Numbers in Ranks 2
How to Rank Name? 4

Back
Top