+ Reply to Thread
Results 1 to 3 of 3

Rank Order Grouped by Date and Time

  1. #1
    Registered User
    Join Date
    04-29-2019
    Location
    Mishawaka, IN
    MS-Off Ver
    10
    Posts
    41

    Rank Order Grouped by Date and Time

    I'm trying to rank order a list grouped by date and time. They should be ranked from earliest to latest and there can't be any ties. I've got them to group and order using the SUMPRODUCT function, but they're in reverse order. I tried to get them to break the ties using the RANK and COUNTIF function, but as you can see from the attached spreadsheet, there's no number 10 in the list? That's weird. I'm somehow going to embed the RANK formula into the SUMPRODUCT formula to achieve the desired ends. But, I have that tie breaker problem I can't seem to surmount. Any and all help would be appreciated. Thank you.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Rank Order Grouped by Date and Time

    Try this to get rank position

    =RANK.EQ(I3,$I$3:$I$13,1)+(COUNTIF($I$3:I3,I3)-1)
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-29-2019
    Location
    Mishawaka, IN
    MS-Off Ver
    10
    Posts
    41

    Re: Rank Order Grouped by Date and Time

    That solves the tie breaker. Thanks.

+ 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. rank each product per customer in date order
    By PGLeeM in forum Excel General
    Replies: 2
    Last Post: 12-24-2019, 07:06 AM
  2. Sort Order with merged, paired, grouped rows.
    By matthew_salter in forum Excel General
    Replies: 21
    Last Post: 12-05-2015, 06:46 PM
  3. Rank Teams in Performance Order - not as easy as just =Rank...
    By excelnat in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2015, 12:12 PM
  4. [SOLVED] Rank or Range grouped rows based on criterial in a different column
    By fredridj in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-14-2013, 03:57 PM
  5. Calculate ship date based on date and time order is received
    By joekomar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2013, 10:57 PM
  6. dragging "rank order" function down, skipping grouped cells
    By theletterh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2012, 06:52 PM
  7. date and time out of order
    By la1tran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2011, 09:05 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