Yesterday on EE I got two solutions to select the countries which have the highest selling numbers in a row on below printscreen:
Concretely the applied formulas are =OFFSET($A$1, 0, MATCH( MAX(B2:E2),B2:E2)) and =INDEX($B$1:$E$1,MATCH(MAX
:E2)), basically both are working except the red marked scenario (where Sweden has 4 as selling and both formulas select Norway incorrectly)
Could you please advise which formula would give correct value for all the scenarios?
Thanks in advance,