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!