![]() |
running totals, named formulas
Another one he
A B C 1 1 2 =TestFormula 2 3 3 =TestFormula 3 4 =A1+B1 (TestFormula) Is there any way to get the following cells to use the correct values, so it would use for C3 the values of row 3, instead as using the formula as noted. With parameters, or something likewise. Or any other means to get this done? problem is that i have very large formula's, if I have to copy them into every cell, everything works correctly, but my worksheet eventually becomes very large... Any ideas, tips or suggestions are welcomed! Already Thanks. |
running totals, named formulas
see reply to your earlier posting
-- Regards Roger Govier "Memento" wrote in message ... Another one he A B C 1 1 2 =TestFormula 2 3 3 =TestFormula 3 4 =A1+B1 (TestFormula) Is there any way to get the following cells to use the correct values, so it would use for C3 the values of row 3, instead as using the formula as noted. With parameters, or something likewise. Or any other means to get this done? problem is that i have very large formula's, if I have to copy them into every cell, everything works correctly, but my worksheet eventually becomes very large... Any ideas, tips or suggestions are welcomed! Already Thanks. |
All times are GMT +1. The time now is 08:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com