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
LVL 1
csehzIT consultantAsked:
Who is Participating?
 
Ryan ChongConnect With a Mentor Commented:
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:
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
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
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
All Courses

From novice to tech pro — start learning today.