csehz
asked on
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):
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
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):
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
Do you know how to enter array formulas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the advices, you are great
=INDEX($B$1:$E$1,MAX(SIGN(