+ Reply to Thread
Results 1 to 3 of 3

Rank with multiple criteria (missing ranks)

  1. #1
    Registered User
    Join Date
    12-01-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Rank with multiple criteria (missing ranks)

    Hello all.
    I'm trying to rank upset picks based on the percentage of correct picks and then the number of correct picks. I'm using a combination of the RANK.EQ, SUMPRODUCT and COUNTIF. My goal is that if there are several ties with the percentage, then the tie breaker should be the number of correct picks. (i.e. if three players all have a 100% correct picks and Player A made 5 picks, Player B made 10 picks and Player C made 2 Picks, then Player B should be ranked 1, Player A ranked 2 and Player C ranked 3). For the most part I think that is working, but as it goes down the nineteen players, the ranks of 12, 14 and 19 are missing.
    I've attached my sheet and I hope all of this makes sense. Thank you in advance for your time and assistance.
    Attached Files Attached Files

  2. #2
    Forum Contributor amit.wilson's Avatar
    Join Date
    07-09-2013
    Location
    Gotham
    MS-Off Ver
    Excel for Mac 2011
    Posts
    283

    Re: Rank with multiple criteria (missing ranks)

    Hello SofaBoy,

    welcome to the forum. I see a problem with the COUNTIF() piece. It counts instances where the count of 'Correct' is the same even when the '%' is different (when it should not).

    Try replacing that with SUMPRODUCT() in H3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    And then copy down.

    Cheers
    <-- If you're happy & you know it...click the star.:-)

  3. #3
    Registered User
    Join Date
    12-01-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Rank with multiple criteria (missing ranks)

    Thank you very much, amit.wilson. Your suggestion worked perfectly!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] RANK bug: same values get different ranks
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 07:05 AM
  2. RANK bug: same values get different ranks
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 06:05 AM
  3. [SOLVED] RANK bug: same values get different ranks
    By Charles Blaquière in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  4. RANK bug: same values get different ranks
    By Charles Blaquière in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] RANK bug: same values get different ranks
    By Charles Blaquière in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-16-2005, 02:05 PM

Tags for this Thread

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