Forum Discussion
Another tricky Dynamic Array problem that I can't solve.
James_Buist An MMULT approach could be something like this:
=MMULT(--(TOROW(C6:C19)=C27:C29),MMULT(--E6:M19,(TOCOL(E3:M3)>=E24:I24)*(TOCOL(E4:M4)<=E25:I25)))Although, the input and output ranges should both include a start and end date for each period (see attached)...
James_Buist An MMULT approach could be something like this:
=MMULT(--(TOROW(C6:C19)=C27:C29),MMULT(--E6:M19,(TOCOL(E3:M3)>=E24:I24)*(TOCOL(E4:M4)<=E25:I25)))
Although, the input and output ranges should both include a start and end date for each period (see attached)...
Brilliant answer as usual. Love the MMULT but just can't quite get my head around creating my own masterpieces with it. Though I’m getting better at tweaking and modifying them. As seen in the reply to the original post, both solutions worked but the MMULT is noticeably faster and much more concise
I have uploaded the xlsx file with the mods I made to bring in a second filter
You should be offering masterclasses on this
