excel array formula

[Najtreg]

Hi,
I want to use array formula's to reduce a very large spreadsheet. VBA
and macros are not to be used, due to the webpublication of this
spreadsheet.

Is there a way to reduce a simulation run with repetitive formula's,
while at the same time the intermediate results are still available.

I came this far:
Run Formula_1 Formula_2 Formula_3
2 1
1 =con1 + D40*con2
2 =con1 + D41*con2
3 =con1 + D42*con2
4 =con1 + D43*con2
5 =con1 + D44*con2
6 =con1 + D45*con2
7 =con1 + D46*con2
8 =con1 + D47*con2
9 =con1 + D48*con2
10 =con1 + D49*con2 =con3*D50 =SUM(con3*D4150+F40:F49)

Is there a way to eliminate the 10 formula_1 copies, like I could in
formula_3?
Limitation: formula_3 still has to use the intermediate results of
formula_1.
Appreciate your help

 

[Bernie Deitrick]

If you need the intermediate results, then an array formula won't help you.

HTH,
Bernie
MS Excel MVP