Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
complex problem
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex Look Up Problem | Excel Worksheet Functions | |||
Complex problem | Excel Programming | |||
COMPLEX PROBLEM | Excel Discussion (Misc queries) | |||
Complex Problem | Excel Worksheet Functions | |||
Complex Sorting Problem | Excel Programming |