RANK & INDEX

  • Thread starter Thread starter RaulDR
  • Start date Start date
R

RaulDR

Hi All!

Is the formula below possible? index function should return the range for
the rank function. It gives me #N/A error

=RANK(I5,INDEX(O5:O20,1,1):INDEX(P5:P20,1,1))

Thanks!
 
Hi Bob!

the first index should return the value "I5" the second index should return
"I8"
the rank formula should use the range "I5:I8"

thanks!
 
Try this then

=RANK(I5,INDIRECT(INDEX(O5:O20,1,1)&":"&INDEX(P5:P20,1,1)))
 
I am assuming that O5:O20, P5:P20 are cell references that you want to pick
up? If so, it should work, it does for me.
 
Hi Bob!

My aplologies... It works perpect! thanks! really appreciate it!
 
You must log in or register to reply here.

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

Index and match 2
INDEX use Question 4
RANK based on result and average 5
Ranking Without Skipping Ranks When a Tie Occurs 4
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Rank Function Help Needed 7
Sumproduct - Return value as Blank 3
rank from low to high 4

Back
Top