• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 100
  • Last Modified:

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:
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?

Thanks in advance,
CountValues-Select_v2.xlsx
0
csehz
Asked:
csehz
1 Solution
 
Ryan ChongCommented:
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
 
csehzIT consultantAuthor Commented:
Thanks that is perfect :)
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now