Array formula and MAX

问题:

I'm trying to get peak/max equity from two columns A & B with an array formula. The reason I use the array formula is because I don't want just MAX as an answer in one cell. I want it to update automatically row after row with each new entry without overwriting previous entry. So far I got to this formula, but it gives me the same result in each row.

=ArrayFormula(if(AD3:AD="","",MAX("<="&row(AD3:AD),AD3:AD,AB2)))

And for clarification I would like it to look something like this:

  AB       AD
PEAK     CLOSED
Equity   Equity
 $1195    $1195
 $1195    $1090
 $1285    $1285
 $1285    $1180
 $1315    $1315
 $1315    $1210
 $1315    $1205

And now with the above formula ( it's in AB3 ) I get just MAX in each row, starting with row AB3 which is $1315.

It can also just give me MAX for column AD, just so it updates on each new row and entry. And here's sample sheet. sample doc

Thank you.

回答1:

=ARRAYFORMULA(IF(A2:A>=B2:B, A2:A, B2:B))