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