Formula selection

Copper Contributor

Please, look at the example of my file. I have to enter a particular formula in F2, that will show the country, which has the most production of Apple company. How can I do it?

4 Replies

@JohnWilson 

See the attached version. It requires Microsoft 365 or Excel 2021.

@JohnWilson 

As an alternative.

=LET(
u,UNIQUE(FILTER($A$2:$A$15,$B$2:$B$15=E2)),
s,SUMIFS($C$2:$C$15,$B$2:$B$15,E2;$A$2:$A$15,u),
m,MAX(s),
FILTER(u,s=m))

@Detlef Lewin 

I guess it shall be comma here

image.png

Of course. I missed that one while translating.