Find repeated values and insert values between the two

[Devicef]

Hello

I am trying to label accounts that have headers that repeat. So the first account would have, for example, beg mid mid2 mid3 end and then it would repeat to the 2nd account with the same headers. So I want to label Account 1 as 1 above the headers and then increase the number to 2 once it reaches account 2 and "beg" repeats. The headers are all in the same row and I want the number also in the same row (Row 3 and 2 respectively).

I attached a file that has the headers and where the numbers should change for the first 3 accounts.

Thank you!

[protonLeah]

Please Login or Register  to view this content.

[Devicef]

Thank you for the response, potonLeah but this isn't what I was looking for, my fault, I should have been more specific. I want every "account" to have a label. All of the accounts in between 1 and 2 to be labeled 1.

Your formula did give me the idea for the one that does fit what I wanted:

Please Login or Register  to view this content.