Need help with correct formula please?

[alexw94]

What forumla can I use in Column C to base a number around Columns A & B, cant describe fully how I want it but this the result I am wanting. Column B is in format DD/MM/YYYY

Column A     Column B    Column C

100                 01/04/2022      1

100                  01/04/2022     1

100                  02/04/2022      2

100                  02/04/2022      2

101                   05/04/2022     1

101                   05/04/2022      1

102                   06/04/2022      1

102                   07/04/2022       2

102                   07/04/2022       2

102                   07/04/2022       2

103                   10/04/2022       1

103                   10/04/2022       1

103                   11/04/2022       2

[#2]

@alexw94 

Can you explain this?

102 07/04/2022 2

102 07/04/2022 3

102 07/04/2022 3

[#3]

Sorry, that was a mistake. I have changed the original post. Well spotted!

[#4]

@alexw94 

Assuming that the data begin in row 2, enter the following formula in C2, then fill down:

=IF(A2<>A1,1,C1+(B2<>B1))