complex problem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top