Need a ranking tie breaker formula.

c3=if(B3="","A","date") and drag down.

After that sort on column A

And second

sort on column C

Then you get the result you want.

Select both columns and sort by date and time.

Your 'Desired' columns have an error.

Originally Posted by john dalton

Hi thanks for the response, I need a formula to create a ranking number to then produce the order to be listed in columns e and f if possible please.

Aren't the red items below reversed?

	E	F
2	Date	Time
3	01/28/2014
4	03/07/2014	14:30
5	05/02/2014
6	05/12/2014
7	05/28/2014	09:00
8	07/02/2014	13:00
9	07/31/2014	11:00
10	08/11/2014	10:30
11	08/11/2014	10:30
12	08/12/2014	10:00
13	08/18/2014	10:30
14	08/18/2014	13:00
15	08/19/2014	09:30
16	08/19/2014
17	08/20/2014
18	08/20/2014	13:00
19	08/21/2014	13:00
20	08/21/2014	14:00
21	08/21/2014	15:00
22	08/26/2014	11:00
23	08/26/2014	13:00

Did you try sorting as I suggested?

Your "times" are not time, they are text that looks like time.

1. Use this in a helper column (which you can hide), and copy down. I used C)...
C3=A3+IF(B3="",0,TIMEVALUE(B3))
Then use this for the ranking, copy down and across...
=INDEX(A$3:A$23,MATCH(SMALL($C$3:$C$23,ROW(A1)),$C$3:$C$23,0))

Did you tried my solution in #2.

I tested it and it will work as your request.