Forum Discussion
Excel array question - spill VOWD based on forecast month
Hi, Can I have your help on a spilled question? I have the following table with information. Fore Month Jan-26 Feb-26 Mar-26 Apr-26 May-26 Jun-26 Jul-26 Aug-26 Sep-26 Oct-2...
My approach is to use a mesh grid of column coordinates and pick out what you need. MGridλ is a generalized function that returns row or column numbers. Here it's returning column numbers.
=LET(
j, MGridλ(MonthlyData, 1),
mdata, IF(j <= ForeMonth, MonthlyData, 0),
totals, BYROW(mdata, SUM),
totals
)This is what it looks like step-by-step: