Forum Discussion
How to dynamically fill formula down into spill range
I have a complex formula that looks for the maximum value in column L over a set of previous rows, provided the dates associated with those previous rows are within 33 days prior to the date associat...
And this
=MAP(L2#, LAMBDA(R, MAX(OFFSET(L2, 0, 0, (ROW(R) - 1)) * (OFFSET(B2, 0, 0, (ROW(R) - 1)) > (OFFSET(B1, ROW(R),0) - 33)) * (OFFSET(A2, (ROW(R) - 2),0) = OFFSET(A1, ROW(R),0)))))