Thread: RANK & INDEX
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RaulDR RaulDR is offline
external usenet poster
 
Posts: 22
Default RANK & INDEX

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!