M
Matt S
Hi all,
I have four variables each with it's own column of data, all the same
length. Each row will give me a new calculated value, say C5 = C1+C2+C3+C4
for example.
Then I want to do a correllation function in C6 that compares C5 to data I
already have and store that correllation number in an array.
Then shift C1 down a row, recalculate C5, recalculate C6, store new
correlation number
Then shift C1 down another row, recalc, store
Shift C1 down three times, then start shifting C2 down three times, then C3,
then C4.
I would love for this to happen in arrays because I'm talking about 81
shifts and recalcs. All data will come from predefined ranges in my workbook.
HELP!!
Thanks!!
Matt
I have four variables each with it's own column of data, all the same
length. Each row will give me a new calculated value, say C5 = C1+C2+C3+C4
for example.
Then I want to do a correllation function in C6 that compares C5 to data I
already have and store that correllation number in an array.
Then shift C1 down a row, recalculate C5, recalculate C6, store new
correlation number
Then shift C1 down another row, recalc, store
Shift C1 down three times, then start shifting C2 down three times, then C3,
then C4.
I would love for this to happen in arrays because I'm talking about 81
shifts and recalcs. All data will come from predefined ranges in my workbook.
HELP!!
Thanks!!
Matt