Results 1 to 9 of 9

How to look for best Scorer if I have two criteria

Threaded View

  1. #1
    Registered User
    Join Date
    05-31-2018
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    2

    How to look for best Scorer if I have two criteria

    Hello everyone,

    I'm stuck and I cant solve the following problem.
    I have to determine the user with the highest achieved score for Criteria A. However, I might have a couple of users who scored the same result for Criteria A. In order to determine the highest scorer I am then looking Criteria B. Out of those who scored the highest result under Criteria A, who actually achieved the best result under Criteria B.

    Screenshot.PNG

    As highlighted in the attached file, the formula that I am looking for should give me the result "User 7".
    Both User 7, User 10 and User 12 achieved the same highest score under Criteria A. Out of the shortlisted users, User 7 scored the highest under Criteria B though. I have to determine this user.

    I think the formula that I am looking for is a combination of Index(), Match() and Sumproduct() and Max()... but I might be wrong.
    Your help is highly appreciated, thank you.
    best regards
    Chris
    Attached Files Attached Files
    Last edited by ChrisCA89; 05-31-2018 at 04:02 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting football results and scorer times from xscores web page into Excel
    By quench in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2018, 10:18 AM
  2. Replies: 2
    Last Post: 02-25-2015, 04:13 PM
  3. Highest scorer with multiple condition
    By Naresh Maloo in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-24-2014, 05:18 AM
  4. highest scorer
    By Naresh Maloo in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 08-23-2014, 06:34 AM
  5. [SOLVED] Need to do ranking top 5 scorer
    By carrillod in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-19-2013, 04:29 PM
  6. [SOLVED] Duplicate Names When Picking Out Highest Scorer
    By webstmonkey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-02-2013, 09:51 PM
  7. Picking out the name and score of the highest scorer
    By jimmymcmahon in forum Excel General
    Replies: 10
    Last Post: 08-06-2011, 05:44 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1