Oct 06 2021 10:54 AM
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?
Oct 06 2021 11:17 AM
See the attached version. It requires Microsoft 365 or Excel 2021.
Oct 06 2021 12:24 PM
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))