Using arrays as variables in excel function

[scottcolbury]

Hi,
I'm trying to create a correlation matrix that expands dynamically as data is inputted into a spreadsheet. I'm having trouble with two areas.

1. How do I define an array of cells as a variable?
2. Once I define those variables, how do I use them in the "correl" function in a cell.

I think I have the rest figured out, but I just can't get past these two.

Thanx in advance,
s_c

 

[NBVC]

To define an array as a variable, activate the array, then go to Insert|Name|Define and enter a variable name.

Repeat for each array.

Then use the names in the Correl function.