On Wed, May 27, 2009 at 10:46 AM, Brian Barker <[email protected]> wrote: > 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
Thanks Brian. Worked perfectly. Mailing lists are so great. Cheers, Mark --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
