Re: using a named cell in a fuction

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 06/13/04 

Date: Sun, 13 Jun 2004 20:17:45 +0200

Hi
use INDIRECT for this if I understood you corectly. So try
=CORREL(INDIRECT(B1),INDIRECT(A3)) 

-- 
Regards
Frank Kabel
Frankfurt, Germany
Josh wrote:
> I have a table with 10 columns and rows. Each column and
> row has a different title that matches an array of cells.
> I'm trying to make a correlation matrix =correl
> (array1,array2)
> 
> i want to make the function so that it takes the
> correlation of the arrays matching its column and row,
> meaning that cell b3 would =correl(b1,a3) where in both
> b1 and a3, there would be a text entry with a name equal
> to that of a named array on another ***. My question is
> how can i have the formula interpret the names in the
> column and row headers as names and not text?
Loading