Hi Bob!

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

"Bob Phillips" wrote:

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.

--
__________________________________
HTH

Bob

"RaulDR" wrote in message
...
Hi Bob!

the formula returns #Value! error

thanks!

"Bob Phillips" wrote:

Try this then

=RANK(I5,INDIRECT(INDEX(O5:O20,1,1)&":"&INDEX(P5:P 20,1,1)))

--
__________________________________
HTH

Bob

"RaulDR" wrote in message
...
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" wrote:

What range are you expecting to get, O5:P20, O5:P5, or what?

--
__________________________________
HTH

Bob

"RaulDR" wrote in message
...
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!