Results 1 to 3 of 3

Ranking list with duplicate values

Threaded View

  1. #1
    Registered User
    Join Date
    02-26-2008
    MS-Off Ver
    Excel 2016
    Posts
    23

    Ranking list with duplicate values

    Hello,
    My company receives orders twice a week. In column A, I have a list of event times. In column B, I have a list of when the shipment arrives for the row's event time. In column C, I would like the rank of the delivery date in ascending order. In my attached spreadsheet Column D shows my desired answer.

    I am trying to work in a table, so it would be helpful to use the table's structured referencing.

    What causes me trouble is that each delivery occurs multiple times in the column, and I want the next delivery to have a rank of 2.
    Also, If the event is in the past, I have the delivery left blank.

    Delivery___,Rnk,I don't want
    Wed 4:00 PM, 1 ,1
    Wed 4:00 PM, 1 ,1
    Wed 4:00 PM, 1 ,1
    Wed 4:00 PM, 1 ,1
    Sat 4:00 PM, 2 ,5
    Sat 4:00 PM, 2 ,5
    Sat 4:00 PM, 2 ,5
    Sat 4:00 PM, 2 ,5
    Sat 4:00 PM, 2 ,5

    Thank you for the help!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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