I have an existing formula that is sort of a cumulative MAX of another column: it has a range covering only the rows above it, inclusive. So B2 is
=MAX(A$1:A2), and I can run this down or auto-fill and the range ends on the current row for each one. But I'd much rather use ARRAYFORMULA to cover an indefinitely long column without further edits.
By analogy with AdamL's answer in Cumulative Sum without Script which I use successfully elsewhere, I am trying:
=ARRAYFORMULA(MAXIFS(A2:A,ROW(A2:A),"<="&ROW(A2:A))) but my result is an array all equal to the value in A2. Other values further down in A are larger, but they are not reported as the MAX() in their respective row.
I don't understand how the SUMIFS one worked and this MAXIFS one doesn't, assuming the semantics are similar.