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

问题描述

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

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".

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

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屋！