Hello to all,
First time poster here so I hope I don't inadverdantly break any taboos around here.
My question involves a simple arrary. Let's say that cell C5 has the arrary {5,6,8,4}.
Now lets say that I am on cell H5 and I need to extract the 2nd value from the known arrary on C5. I believe that the Index function is what's necessary. According to the Index function, 3 arguments are required, the array, the row number and the column number. Is it possible to specify a cell value that has a current array within as the array arguement for the Index function? Am i completely approaching this wrong? Please let me know if i've confused everyone here as much myself.
thank you
This message was edited by huskylord on 2002-04-02 07:52
First time poster here so I hope I don't inadverdantly break any taboos around here.
My question involves a simple arrary. Let's say that cell C5 has the arrary {5,6,8,4}.
Now lets say that I am on cell H5 and I need to extract the 2nd value from the known arrary on C5. I believe that the Index function is what's necessary. According to the Index function, 3 arguments are required, the array, the row number and the column number. Is it possible to specify a cell value that has a current array within as the array arguement for the Index function? Am i completely approaching this wrong? Please let me know if i've confused everyone here as much myself.
thank you
This message was edited by huskylord on 2002-04-02 07:52