Times Numbered

[kristofor]

Hello!

I am looking for a formula that lists a new number ever time a new time would appear. For example (7:16, 7:16, 8:34, 9:25 = 1,1,2,3)

the only problem is, i need this to start over every time a new day appears in another column.

i hope that's clear and that someone can help.

 

[jasonb75]

The easiest way would be to add date and time together in a new column, then rank that column with a formula like

=SUMPRODUCT(1/COUNTIF(C$2:C2,C$2:C2))

Where C2 hods the first combined date and time.

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you mean?

Excel 365 (Windows) 32 bit
	A	B	C
1	Date	Time	Seq
2	01-Oct-19	7:16	1
3	01-Oct-19	7:16	1
4	01-Oct-19	8:34	2
5	01-Oct-19	9:25	3
6	02-Oct-19	10:32	1
7	02-Oct-19	11:15	2
8	02-Oct-19	11:15	2
9	02-Oct-19	11:15	2
10	02-Oct-19	12:01	3
11	03-Oct-19	6:24	1
12	04-Oct-19	7:00	1
Sequence per day

Cell Formulas
Range	Formula
C2	=IF(A2<>A1,1,C1+(B2<>B1))