Solved

Excel 2010 - Select category per Max values v.2

Posted on 2016-10-06
2
54 Views
Last Modified: 2016-10-06
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
Comment
Question by:csehz
2 Comments
 
LVL 50

Accepted Solution

by:
Ryan Chong earned 500 total points
ID: 41831297
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
 
LVL 1

Author Closing Comment

by:csehz
ID: 41831318
Thanks that is perfect :)
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question