+ Reply to Thread
Results 1 to 3 of 3

Unique Ranking with Multiple Criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    05-08-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    6

    Unique Ranking with Multiple Criteria

    Hi,

    Using the formula below, I was able to rank using multiple criteria, but this formula spits out duplicate ranks (1,1,3) and I need it to shoot out unique ranks (1,2,3).

    =SUMPRODUCT((B3=B$3:B$9)*(C3<C$3:C$9))+1

    Data Set:
    Berry 12/31/2017
    Orange 3/22/2017
    Apple 3/31/2017
    Berry 3/22/2017
    Apple 6/30/2017
    Apple 6/30/2017
    Orange 3/22/2017
    Orange 4/18/2017

    Is there a solution for this?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,952

    Re: Unique Ranking with Multiple Criteria

    https://www.excelforum.com/excel-gen...-criteria.html
    Ben Van Johnson

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2504
    Posts
    13,725

    Re: Unique Ranking with Multiple Criteria

    And there is response there, too.
    Dave

+ 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. Unique Ranking with Multiple Criteria
    By dglenski in forum Excel General
    Replies: 7
    Last Post: 05-09-2017, 01:05 AM
  2. Ranking - multiple criteria
    By Lugashz in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-14-2015, 09:09 AM
  3. Unique ranking by multiple criteria
    By reggie1000 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-21-2015, 08:03 AM
  4. Multiple Criteria Ranking
    By Keelin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2014, 01:32 AM
  5. [SOLVED] multiple criteria conditional ranking and protecting multiple sheets in one go
    By samktlim in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-31-2013, 09:31 AM
  6. Replies: 14
    Last Post: 05-23-2012, 08:09 PM
  7. Multiple Ranking Criteria
    By Bullfn33 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-13-2007, 04:12 PM

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