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

Excel 2010 - Select category per Max values

Dear Experts,

Can you please have a short look on the attached file, basically on 'Sheet1' there is a small table with Products, which contains selling numbers per Countries (from column A to E):
Count and Select
Could you advise which Excel formula could provide result as color marked in column F? The logic of it is selecting that country from the header, which has the Max of selling at the certain product.

Thanks in advance,
CountValues-Select.xlsx
0
csehz
Asked:
csehz
  • 3
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
Try this ARRAY formula

=INDEX($B$1:$E$1,MAX(SIGN(B2:E2)*COLUMN(B2:E2))-1)
0
 
Saqib Husain, SyedEngineerCommented:
Do you know how to enter array formulas?
0
 
Ryan ChongCommented:
try use formula:
=OFFSET($A$1, 0, MATCH( MAX(B2:E2),B2:E2))

Open in new window

CountValues-Select_b.xlsx
0
 
Saqib Husain, SyedEngineerCommented:
Reread your criteria

=INDEX($B$1:$E$1,MATCH(MAX(B2:E2),B2:E2))
0
 
csehzIT consultantAuthor Commented:
Thank you for the advices, you are great
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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