MaxIf与关联的行信息? [英] MaxIf with associated row info?

问题描述

Im使用数组公式确定行数据的特定子集的最大值:

Im using array formulas to determine the maximum value of a specific subset of row data:

=MAX(($A2:$A100="somestring")*($C2:$C100))

这可以正常工作&让我得到C中的最大值，其中A ="somestring".

This works fine & gets me the maximum value in C where A = "somestring".

现在，我想返回与此"max"行关联的其他字符串值.凭直觉，我认为我可能需要放弃布尔逻辑乘法策略，因为涉及到字符串值.最好/最干净的方法是什么?

Now, I want to return other column values associated with this "max" row that are strings. Intuitively I think I may need to ditch the boolean logic multiplication strategy since string values are getting involved. What's the best/cleanest way to go about this?

推荐答案

尝试一下:

=INDEX(B1:B100,MATCH(MAX((A1:A100="somestring")*(C1:C100)),(A1:A100="somestring")*(C1:C100),0))

在此示例中，您想要为其设置值的列设置为B.

Column you want values for is set to B in this example.

这篇关于MaxIf与关联的行信息?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！