Using arrays as variables in excel function

scottcolbury

New Member
Joined
Dec 6, 2005
Messages
45
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
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,035
Messages
5,569,782
Members
412,292
Latest member
The Bear named Joe
Top