Forum Discussion
Re: Dynamic Arrays - Extend the last logical row value in a 2D array
I put a non-zero escalation in simply to demonstrate the functionality. Setting growth to zero or omitting it from the formula would flat line the forecast as you suggested. Yes, SCAN will pick up the gaps in actuals as you suggest.
The green conditional format makes it somewhat obvious. You could STACK your flag with the actuals as a thunk array and scan that, but I would aim to get simpler things going before embarking on that.
1 Reply
- I may just do that as I can't think of another solution now and need to get this out. Can revise later id a better one. But stacking as a thunk array wold work. I've been meaning to get my head around those so perhaps this is a good opportunity. I have a sample to work from and hope I can get that working. Thanks for the pointer. A week ago I wouldn't have understood what you meant!!
