RANK & INDEX

[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(P520,1,1))

Thanks!

 

[Bob Phillips]

What range are you expecting to get, O520, O55, or what?

 

[RaulDR]

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!

 

[Bob Phillips]

Try this then

=RANK(I5,INDIRECT(INDEX(O5:O20,1,1)&":"&INDEX(P520,1,1)))

 

[RaulDR]

Hi Bob!

the formula returns #Value! error

thanks!

 

[Bob Phillips]

I am assuming that O5:O20, P520 are cell references that you want to pick
up? If so, it should work, it does for me.

 

[RaulDR]

Hi Bob!

My aplologies... It works perpect! thanks! really appreciate it!