Hello all - I'm trying to spill the results of a horizontal dynamic spilled array. For this let's just use the example SEQUENCE(,7).
I would like to display those 7 results but only between 2 dates of a projection for construction costs. It does not work
and returns spill errors even if I use something like IF(AND(month>=startmonth,month<=end month),SEQUENCE(,7). Old school straight line results are not acceptable in this case.
The projected dates are 1-60 for 5 years; SEQUENCE(,60). Please help, thank you. I need the numbers 1-7 showing in months 4-10 without causing #SPILL errors. Note my results are not linear, they are based on a curve.
I would like to display those 7 results but only between 2 dates of a projection for construction costs. It does not work
and returns spill errors even if I use something like IF(AND(month>=startmonth,month<=end month),SEQUENCE(,7). Old school straight line results are not acceptable in this case.
The projected dates are 1-60 for 5 years; SEQUENCE(,60). Please help, thank you. I need the numbers 1-7 showing in months 4-10 without causing #SPILL errors. Note my results are not linear, they are based on a curve.
Month # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
=SEQUENCE(,7) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||||||
Start Month | 4 | ||||||||||||
End Month | 10 | ||||||||||||
# of Months | 7 |