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...
=MAP(INDIRECT("A2:A"&COUNTA(A:A)+1),INDIRECT("B2:B"&COUNTA(A:A)+1),INDIRECT("L2:L"&COUNTA(A:A)+1),LAMBDA(colA,colB,colL,MAXIFS(L$2:colL,B$2:colB,">"&OFFSET(colB,1,0)-33,A$2:colA,"="&OFFSET(colA,1,0))))Does this return the expected result?