|
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! |
RANK & INDEX
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! |
RANK & INDEX
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! |
RANK & INDEX
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! |
RANK & INDEX
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! |
RANK & INDEX
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! |
RANK & INDEX
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! |
| All times are GMT +1. The time now is 05:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com