Solved

Excel 2010 - Select category per Max values v.2

Posted on 2016-10-06
2
34 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 49

Accepted Solution

by:
Ryan Chong earned 500 total points
Comment Utility
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
Comment Utility
Thanks that is perfect :)
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article will show you how to use shortcut menus in the Access run-time environment.
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…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now