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