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
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,"") |