Help with formula Number serial based on criteria monthly

[Lukma]

Hi Friends

I have my Month in Column A
And i have My Vessel name In Column C
and i Have the MUS No Column D
The solution formula i need in Column E is to Number for each month and when it get to the following month number should start from One again

so my Example i placed in Dec-22 she 123456, so in Jan-2023 i should have 12345

Appreciate and formula that could number based on criteria

REgards

Onshore Vessel Jetty activity Tracking From 2022-2023.xlsx
	A	B	C	D	E	F	G
1	Month	Zone	Supply Vessel	Mus No	Trip	Channel Waiting Time & VTS Delay	Start Date & Time (Arrival Time at MOSB)
2	Dec 22		A-CHLOE	3206	1		03/12/22 17:20
3	Dec 22		A-CHLOE	3250	2		08/12/22 07:00
4	Dec 22		A-CHLOE	3290	3		14/12/22 06:05
5	Dec 22		A-CHLOE	3345	4		18/12/22 05:30
6	Dec 22		A-CHLOE	3376	5		22/12/22 00:25
7	Dec 22		A-CHLOE	3431	6		27/12/22 00:15
8	Jan 23		A-CHLOE	12			02/01/23 06:20
9	Jan 23		A-CHLOE	55			07/01/23 01:20
10	Jan 23		A-CHLOE	99			11/01/23 18:30
11	Jan 23		A-CHLOE	161			19/01/23 01:10
12	Jan 23		A-CHLOE	220			25/01/23 08:50
13	Feb 23		A-CHLOE	278			02/02/23 07:00
14	Feb 23		A-CHLOE	319			06/02/23 01:30
15	Feb 23		A-CHLOE	391			14/02/23 02:40
16	Feb 23		A-CHLOE	438			18/02/23 07:35
17	Feb 23		A-CHLOE	461			23/02/23 14:15
18	Feb 23		A-CHLOE	504			27/02/23 04:10
19	Mar 23		A-CHLOE	545			02/03/23 01:15
20	Mar 23		A-CHLOE	600			07/03/23 14:15
21	Mar 23		A-CHLOE	652			12/03/23 02:45
22	Mar 23		A-CHLOE	725			18/03/23 08:35
23	Mar 23		A-CHLOE	782			25/03/23 01:25
24	Mar 23		A-CHLOE	827			29/03/23 01:30
2023_Data_Vessel_Trip

Cell Formulas
Range	Formula
A2:A24	A2	=IFERROR(EOMONTH(G2,-1)+1,"")

 

[SunnyAlv]

Like this ?

=COUNTIF($A$2:A2,A2)

 

[Peter_SSs]

If the post #2 results are what you want and your data is reasonably large, the following formula would be faster and consume less calculation resources.

24 03 14.xlsm
	A	B	C	D	E
1	Month	Zone	Supply Vessel	Mus No	Trip
2	Dec 22		A-CHLOE	3206	1
3	Dec 22		A-CHLOE	3250	2
4	Dec 22		A-CHLOE	3290	3
5	Dec 22		A-CHLOE	3345	4
6	Dec 22		A-CHLOE	3376	5
7	Dec 22		A-CHLOE	3431	6
8	Jan 23		A-CHLOE	12	1
9	Jan 23		A-CHLOE	55	2
10	Jan 23		A-CHLOE	99	3
11	Jan 23		A-CHLOE	161	4
12	Jan 23		A-CHLOE	220	5
13	Feb 23		A-CHLOE	278	1
14	Feb 23		A-CHLOE	319	2
15	Feb 23		A-CHLOE	391	3
16	Feb 23		A-CHLOE	438	4
17	Feb 23		A-CHLOE	461	5
18	Feb 23		A-CHLOE	504	6
19	Mar 23		A-CHLOE	545	1
20	Mar 23		A-CHLOE	600	2
21	Mar 23		A-CHLOE	652	3
22	Mar 23		A-CHLOE	725	4
23	Mar 23		A-CHLOE	782	5
24	Mar 23		A-CHLOE	827	6
Counter

Cell Formulas
Range	Formula
A2:A24	A2	=IFERROR(EOMONTH(G2,-1)+1,"")
E2:E24	E2	=1+IF(A2=A1,E1,0)

 

[Lukma]

Thanks Peter

 

[Peter_SSs]

You're welcome.