Resetting values based on change in cells of other column

I need help with doing the following logic in my worksheet

A B C
1 1 1
1 2 2
1 3 3
2 4 1
2 5 2

I want column C to restart its incrementing whenever column switches to a
new value.


Any help would be appreciated.

From you example, you want column C to increment unless Column A changes

manually put 1 in C1 first

Put =IF(A2=A1,C1+1,1)
in cell C2 and copy down.
--
Gary's Student


"NSteinner" wrote:

> I need help with doing the following logic in my worksheet
>
> A B C
> 1 1 1
> 1 2 2
> 1 3 3
> 2 4 1
> 2 5 2
>
> I want column C to restart its incrementing whenever column switches to a
> new value.
>
>
> Any help would be appreciated.
>
>