At 10:18 27/05/2009 -0700, Mark Knecht wrote:
I'm trying to build a simple correlation matrix. I have 3 named
arrays - Array1, Array2 & Array3. I can do this by putting the array
names in the functions explicitly without problem, but I don't know
how to do this when the name of an array is held in a cell.
Easy and works:
=Correl(Array1,Array2)
What I'd like to do is put the array names Array1, Array2 and Array3
in cells surrounding the matrix and reference those cells to get the names:
[...]
How do I reference a cell that holds a name and then use the
contents of that cell as an argument to the correlation function?
This is easy when you know how! You need just to use the INDIRECT()
function. Use something like
=CORREL(INDIRECT(xx);INDIRECT(yy))
- where xx and yy are the cells containing the names of the relevant arrays.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
