Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #482 www.energyefficientbuild.com
My following solution to the problem came about from a discussion with my dear friend and fellow Top Contributor on Google Docs Help forum TedJ -- a simple row by row formula sported a rather straightforward solution, but the idea was to come up with an arrayformula that will lend itself for auto propagation in use with Form input.
----------------------------------------------------
so here we go ... I realize it is a pretty convoluted solution ... and if I come up with a simpler and/or more streamlined solution, i will post an update ...
My following solution to the problem came about from a discussion with my dear friend and fellow Top Contributor on Google Docs Help forum TedJ -- a simple row by row formula sported a rather straightforward solution, but the idea was to come up with an arrayformula that will lend itself for auto propagation in use with Form input.
----------------------------------------------------
so here we go ... I realize it is a pretty convoluted solution ... and if I come up with a simpler and/or more streamlined solution, i will post an update ...
No comments:
Post a Comment