Thursday, September 25, 2014

yogi_Formula For Computed Unique Task Nos Array Computation

                    Google Spreadsheet   Post  #1771
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-25-2014
post by  Raivis:
(https://productforums.google.com/forum/#!mydiscussions/docs/Hh-hrLyLwo4)
How to have array formula that calculates the next array value from the previous value?
Hi,

Is that possible?

I have shared this spreadsheet as an example. Cell G6 is calculated correctly by my array formula, however, all the preceding values are not correct. I have shown the expected values in column J.

What am I trying to achieve?
- I want to be able to provide for task Y either its start date or some other preceding task X (in this case it would take task's X end date and add one business day), and calculate the start/ end business day dates of task Y with the array formula. 


Some notes:
- The cells within red border are not calculated correctly by my current formula
- All grey cells are calculated by formulas
- All the white cells contain either array formulas or values entered by a user
- For more information about particular cells look at the cell notes
Regards
---
Hey Adam,

Thank you for looking into it again! I am trying to avoid script for now.

In my mind, this problem is very similar to the one in this sheet, however, the sheet looks way more simple. The grey cells contain simple non-array formulas and I am looking for a way to replace them with an array formula.


Cheers,
Raivis
-------------------------------------------------------------------------------------------------------------------------------------