Resetting values based on change in cells of other column

N

NSteinner

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.
 
G

Gary's Student

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.
 
Top