数组公式和MAX [英] Array formula and MAX

问题描述

我正在尝试从两列A&中获得最高/最高净值B具有数组公式.我使用数组公式的原因是因为我不想仅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

现在有了上面的公式(在AB3中)，我每行仅得到MAX，从AB3行开始为$ 1315.

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

它也可以给我AD列的MAX，以便它在每个新行和每个条目上更新.这是样本表. 示例文档

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

谢谢.

推荐答案

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

这篇关于数组公式和MAX的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！