• Status: Solved
• Priority: Medium
• Security: Public
• Views: 107

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:

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?

CountValues-Select_v2.xlsx
0
csehz
1 Solution

Commented:
oooops, try use this formula instead:

=OFFSET(\$A\$1, 0, MATCH( MAX(B2:E2),B2:E2, 0))

or

=INDEX(\$B\$1:\$E\$1,MATCH(MAX(B2:E2),B2:E2, 0))
CountValues-Select_v2_b.xlsx
0

IT consultantAuthor Commented:
Thanks that is perfect :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.