Counter without using a macro

[JasonGreeley]

This maybe a bit of stretch but please let me know if this can be done without vba programming, I'll keep it simple...

I have 2 Columns. I would like to use an excel formula to calculate the contents of Column B, need a formula to keep entering 1, for B1, B2, B3... until A# is = C, then enter 2, for B4, B5, and so on

Column A..........Column B
.....................1
.....................1
C.....................1
.....................2
.....................2
.....................2
C.....................2
.....................3
C.....................3
.....................4
.....................4

...upto 100

Hope that this is clear! Thanks, and I would appreciate any feedback

 

[mikerickson]

In B1 put 1
in B2 put the formula =B1+(A2="C")

 

[xld]

B1: 1
B2: =IF(A2="C",B1+1,B1)

copy B2 down

 

[JasonGreeley]

In B1 put 1
in B2 put the formula =B1+(A2="C")

Thanks!!!