| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
| RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
| Rank where lowest value is highest rank | Excel Worksheet Functions | |||
| Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(. | Excel Worksheet Functions | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
Linear Mode
