Formula to auto-number rows for multiple projects within a single sheet

PCG

Hello,

I'm looking to a formula that will auto-number rows for multiple projects within a single sheet. For example, I have rows for Project A, Project B, and Project C in the same sheet:

Project A

Project A

Project A

Project B

Project B

Project B

Project B

Project C

Project C

I want my auto-number column to return the following:

1

2

3

1

2

3

4

1

2

Is there a formula that can solve for this?

Thank you in advance!

Paul Newcome

Insert an auto number column (called "Auto") with no special formatting. Then use this formula in a separate column:

=COUNTIFS(Auto:Auto, @cell <= Auto@row, [Project Name Column]:[Project Name Column], @cell = [Project Name Column]@row)

PCG

@Paul Newcome This worked perfectly, thank you so much!

Paul Newcome

Happy to help. 👍️