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
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