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!!
Bookmarks