Sequentially name cells based on date total count

[trentdowd]

Hi Guys,


Is there an easy way to sequentially number cells adjacent to a list of dates?

The goal is the come up with a count of how many times a date is listed in the sheet for all the dates in the sheet, so on the November 1st, there could be 16 entries, on the November 2nd there could be 14 and so on. I am not just looking for the total but the actual count in succession order- (this example below was done by flash filling in series "date by date" by eye... but i have then of thousands of dates to accomplish . Is there some kind of method which can automatically flash fill the accurate amount into adjacent cells based on the number on the total amount a date is in the sheet.

1​	01/11/2019​
2​	01/11/2019​
3​	01/11/2019​
4​	01/11/2019​
5​	01/11/2019​
6​	01/11/2019​
7​	01/11/2019​
8​	01/11/2019​
9​	01/11/2019​
10​	01/11/2019​
11​	01/11/2019​
12​	01/11/2019​
13​	01/11/2019​
14​	01/11/2019​
15​	01/11/2019​
16​	01/11/2019​
1​	02/11/2019​
2​	02/11/2019​
3​	02/11/2019​
4​	02/11/2019​
5​	02/11/2019​
6​	02/11/2019​
7​	02/11/2019​
8​	02/11/2019​
9​	02/11/2019​
10​	02/11/2019​
11​	02/11/2019​
12​	02/11/2019​
13​	02/11/2019​
14​	02/11/2019​

Many thanks

 

[DanteAmor]

Try this

Dante Amor
	A	B
1	Sequence	Date
2	1	01/01/2019
3	2	01/01/2019
4	3	01/01/2019
5	4	01/01/2019
6	5	01/01/2019
7	6	01/01/2019
8	7	01/01/2019
9	8	01/01/2019
10	9	01/01/2019
11	10	01/01/2019
12	11	01/01/2019
13	12	01/01/2019
14	13	01/01/2019
15	14	01/01/2019
16	15	01/01/2019
17	16	01/01/2019
18	1	02/11/2019
19	2	02/11/2019
20	3	02/11/2019
21	4	02/11/2019
22	5	02/11/2019
23	6	02/11/2019
24	7	02/11/2019
25	8	02/11/2019
26	9	02/11/2019
27	10	02/11/2019
28	11	02/11/2019
29	12	02/11/2019
30	13	02/11/2019
31	14	02/11/2019
Hoja6

Cell Formulas
Range	Formula
A2:A31	A2	=COUNTIF($B$2:B2,B2)

 

[trentdowd]

Try this

Dante Amor
	A	B
1	Sequence	Date
2	1	01/01/2019
3	2	01/01/2019
4	3	01/01/2019
5	4	01/01/2019
6	5	01/01/2019
7	6	01/01/2019
8	7	01/01/2019
9	8	01/01/2019
10	9	01/01/2019
11	10	01/01/2019
12	11	01/01/2019
13	12	01/01/2019
14	13	01/01/2019
15	14	01/01/2019
16	15	01/01/2019
17	16	01/01/2019
18	1	02/11/2019
19	2	02/11/2019
20	3	02/11/2019
21	4	02/11/2019
22	5	02/11/2019
23	6	02/11/2019
24	7	02/11/2019
25	8	02/11/2019
26	9	02/11/2019
27	10	02/11/2019
28	11	02/11/2019
29	12	02/11/2019
30	13	02/11/2019
31	14	02/11/2019
Hoja6

Cell Formulas
Range	Formula
A2:A31	A2	=COUNTIF($B$2:B2,B2)

Thanks very much, I will start to now look into Count functions.. very handy!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[trentdowd]

Hi guys - just to report I finally got this working for all the cells in my sheet! Formatting errors for the date and time through it off at the start AND out of about 60K cells there's around 50 cells that have thrown up #VALUE errors but I can sure live with that and plan of debugging it in the future. Thanks for all your help!