+ Reply to Thread
Results 1 to 3 of 3

Count Rank with Multiple Criteria

Hybrid View

  1. 05-15-2020, 12:08 AM #1
    journey0717
    journey0717 is offline
    Registered User
    Join Date
    02-03-2020
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    28

    Count Rank with Multiple Criteria

    Hi, I have been using formula to do the rank count based on multiple column criteria but seem like it was not ideal.

    COUNTIF($C$3:$C$4850,">"&$C3)+COUNTIFS($E$3:$E$4850,$E3,$F$3:$F$4850,">"&$F3)+1

    Rank should follow the largest to lowest based on earned points, follow by it criteria on largest number of round and largest number of rate to finalized the ranking number.

    Please advise. Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-15-2020, 12:43 AM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: Count Rank with Multiple Criteria

    Please try at F2

    =SUMPRODUCT(--($B$2:$B$15*10^9+$D$2:$D$15*10^6+$E$2:$E$15-ROW(B$2:B$15)/1000>B2*10^9+D2*10^6+E2-ROW(B2)/1000))+1
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 05-15-2020, 04:52 AM #3
    journey0717
    journey0717 is offline
    Registered User
    Join Date
    02-03-2020
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    28

    Re: Count Rank with Multiple Criteria

    Hi Bo_Ry, i have never use the formula SUMPRODUCT before. Please share with me what is the difference of *10^9 and *10^6 as well as ROW.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 Formula multiple criteria
    By excelxzzx in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-04-2020, 12:33 PM
  2. Rank and MAX dependent on multiple criteria
    By clairebear4_4 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2017, 06:30 PM
  3. Rank with Multiple Criteria
    By abbeyrd237 in forum Excel General
    Replies: 4
    Last Post: 06-21-2016, 12:52 AM
  4. Rank function with multiple criteria
    By chr15williams in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-29-2015, 02:21 PM
  5. [SOLVED] Index Match Rank with Multiple Criteria
    By Blake 7 in forum Excel General
    Replies: 9
    Last Post: 12-04-2014, 10:44 AM
  6. [SOLVED] Rank/Sort that removes or doesn't count information of specific criteria
    By ehatz in forum Excel General
    Replies: 2
    Last Post: 09-25-2014, 02:22 PM
  7. rank according to multiple criteria
    By melvil in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-11-2014, 08:21 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1