excel-使用MAXIFS(在excel 2010中) [英] excel - Use of MAXIFS (in excel 2010)

问题描述

我想解决库存问题.我在特定商店中有一些商品的存货，我想找出在同一国家/地区的哪个商店中该特定商品的存货最高.

I want to solve a stock problem. I have stock from some articles in a specific store and I want to find out which store in the same country has the highest stock of this specific item.

我将下表用于信息输入

A组:商品编号

哥伦比亚B:国家/地区

Colom B: Country

Colom C:股票

Colom C: Stock

Colom D:商店编号

Colom D: Store number

例如:

我想知道荷兰的884条文章，哪家商店的库存最多.结果将是存储1.

I would like to know for article 884 in Netherlands, which store has the highest stock. The outcome would be store 1.

我无法使用公式MAXIFS :(. 有可能变通并得到相同的答案吗?

I'm not able to use the formulas MAXIFS :(. Is there a possibility to work around and get the same answer?

推荐答案

尽管您可以按照我的评论在数组中使用MAX和IF进行操作(另请参见

Whilst you could do as per my comment using MAX and IF in an array (also see this page for some additional information), you can also try the following:

G3中的公式:

=INDEX(D2:D7,MATCH(1,INDEX((A2:A7=G1)*(B2:B7=G2)*(C2:C7=MAX(INDEX((A2:A7=G1)*(B2:B7=G2)*(C2:C7),))),),0))

或者用荷兰语(我想你是)

Or in Dutch (I assume you are)

=INDEX(D2:D7;VERGELIJKEN(1;INDEX((A2:A7=G1)*(B2:B7=G2)*(C2:C7=MAX(INDEX((A2:A7=G1)*(B2:B7=G2)*(C2:C7);))););0))

这篇关于excel-使用MAXIFS(在excel 2010中)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！