Create numbering sequence within groups

[FryGirl]

I'm currently using =IF(B1=B2,C1,MAX($C$1:C1)+1) in column C and it works fine to establish a sequential numbering, but not sure how to adjust for a new year.

Data Range
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

Year​

[/TD]
[TD]

Team​

[/TD]
[TD]

Series​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

11​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

12​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

13​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team1​

[/TD]
[TD]

4​

[/TD]
[/TR]
[TR]
[TD]

14​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team1​

[/TD]
[TD]

4​

[/TD]
[/TR]
[TR]
[TD]

15​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team2​

[/TD]
[TD]

5​

[/TD]
[/TR]
[TR]
[TD]

16​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team2​

[/TD]
[TD]

5​

[/TD]
[/TR]
[TR]
[TD]

17​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team2​

[/TD]
[TD]

5​

[/TD]
[/TR]
[TR]
[TD]

18​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team2​

[/TD]
[TD]

5​

[/TD]
[/TR]
[TR]
[TD]

19​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team2​

[/TD]
[TD]

5​

[/TD]
[/TR]
[TR]
[TD]

20​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team3​

[/TD]
[TD]

6​

[/TD]
[/TR]
[TR]
[TD]

21​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team3​

[/TD]
[TD]

6​

[/TD]
[/TR]
[TR]
[TD]

22​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team3​

[/TD]
[TD]

6​

[/TD]
[/TR]
[TR]
[TD]

23​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team3​

[/TD]
[TD]

6​

[/TD]
[/TR]
</tbody>[/TABLE]

Would like
Data Range
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

Year​

[/TD]
[TD]

Team​

[/TD]
[TD]

Series​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

11​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

12​

[/TD]
[TD]

2018​

[/TD]
[TD]

Team3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

13​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

14​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

15​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

16​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

17​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

18​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

19​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team2​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

20​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

21​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

22​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

23​

[/TD]
[TD]

2019​

[/TD]
[TD]

Team3​

[/TD]
[TD]

3​

[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

It looks like you already did re-post it here: Formula Advice on creating a group of sequence numbers to restart after 20 rows

 

[VBA learner ITG]

That really complicates it a bit, and really is a question deserving of its own thread (instead of tacking on to an old, existing one posted by someone else).
You will get more people looking at it too, if it is in a new, unanswered thread.

Be sure to be detailed in your question, and include screen prints of the data, so people can see exactly what you are working with and what you would like to happen.

Thank you for your time. I have started a new thread as per your recommendation.