如何获得左侧单元格的最小列 [英] How to get minimum of a column with left side cell

问题描述

在我的excel工作表中. A栏保留产品名称，B栏保留其奖项.

我得到了最低奖金使用公式.
= min(B2:B12)

我们如何获得低价产品名称及其奖品.

In my excel worksheet . Column A hold Products names and column B hold its Prize .

I get minimum prize use formula .
=min(B2:B12)

How can we get Low prize Product name and its Prize.

推荐答案

假设A2:A12是您产品名称的范围，而B2:B12是您产品名称的范围奖品.

将此功能添加到A14:

Assuming that A2:A12 is the range of your product names and B2:B12 is the range of your prizes.

Add this function to A14:

=INDEX(A2:A12;MATCH(MIN(B2:B12);B2:B12;0);1)

并将此功能添加到B14:

and add this function to B14:

=INDEX(B2:B12;MATCH(MIN(B2:B12);B2:B12;0);1)

这应该在第14行显示与最低价格匹配的第一行的值.

This should display on line 14 the values of the first line that matches the minimum price.

这篇关于如何获得左侧单元格的最小列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！