Formula selection

%3CLINGO-SUB%20id%3D%22lingo-sub-2818837%22%20slang%3D%22en-US%22%3EFormula%20selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2818837%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%2C%20look%20at%20the%20example%20of%20my%20file.%20I%20have%20to%20enter%20a%20particular%20formula%20in%20F2%2C%20that%20will%20show%20the%20country%2C%20which%20has%20the%20most%20production%20of%20Apple%20company.%20How%20can%20I%20do%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2818837%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2818937%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2818937%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1152265%22%20target%3D%22_blank%22%3E%40JohnWilson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%20It%20requires%20Microsoft%20365%20or%20Excel%202021.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2819270%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2819270%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1152265%22%20target%3D%22_blank%22%3E%40JohnWilson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20an%20alternative.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DLET(%0Au%2CUNIQUE(FILTER(%24A%242%3A%24A%2415%2C%24B%242%3A%24B%2415%3DE2))%2C%0As%2CSUMIFS(%24C%242%3A%24C%2415%2C%24B%242%3A%24B%2415%2CE2%3B%24A%242%3A%24A%2415%2Cu)%2C%0Am%2CMAX(s)%2C%0AFILTER(u%2Cs%3Dm))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional 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.