Link to home
Start Free TrialLog in
Avatar of csehz
csehzFlag for Hungary

asked on

Excel 2010 - Select category per Max values v.2

Dear Experts,

Yesterday on EE I got two solutions to select the countries which have the highest selling numbers in a row on below printscreen:
User generated image
Concretely the applied formulas are =OFFSET($A$1, 0, MATCH( MAX(B2:E2),B2:E2)) and =INDEX($B$1:$E$1,MATCH(MAX(B2:E2),B2: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,
CountValues-Select_v2.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of csehz

ASKER

Thanks that is perfect :)