Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDES and #Value!
I am using INDEX for the first time with Excel 2003. Column A is a list of
names (rows 1-9 are populated, A10 & A13 are blank, A11,A12 and A14 are also populated. I am using the functiion to extract a name at random when F9 is pushed. the function is INDEX($A:$A,$f$3,$A:$A) where F3 is a random number generator and A:A is a column of 14 names. As an experiment, I populated cells f4 to f20 with the exact same INDEX function as shown previously. Cells F4 to F12 and F14 give the following result: #VALUE! while at the same time cells F13 and f15-F20 display the same name from the list. Each push of the F9 key causes the INDEX to work as expected except for the #VALUE!. How can the #VALUE! be stopped? The random number is always within the expected range. Thanks, CJ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDES and #Value!
I was able to solve my own problem: solution
INDEX($A:$A,$f$3,1) "CJ" wrote: I am using INDEX for the first time with Excel 2003. Column A is a list of names (rows 1-9 are populated, A10 & A13 are blank, A11,A12 and A14 are also populated. I am using the functiion to extract a name at random when F9 is pushed. the function is INDEX($A:$A,$f$3,$A:$A) where F3 is a random number generator and A:A is a column of 14 names. As an experiment, I populated cells f4 to f20 with the exact same INDEX function as shown previously. Cells F4 to F12 and F14 give the following result: #VALUE! while at the same time cells F13 and f15-F20 display the same name from the list. Each push of the F9 key causes the INDEX to work as expected except for the #VALUE!. How can the #VALUE! be stopped? The random number is always within the expected range. Thanks, CJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|