Add 1 in range B2:B2000 according to column C2:C2000

[HaroonSid]

Hello
i have data in range C2:C2000
e.g
c2 = a
c3 = a
c4 = a
c5 = a
c6 = b
c7 = b
c8 = c
c9 = c
c10 = c
c11 = c
c12 = d
c13 = e
c14 = f
c15 = f
.....
c2000 = ?

then i want
B2 = 1
B6 = 1
B8 = 1
B12 = 1
B13 = 1
B14 = 1

put 1 according to column C2:C2000 where first word end then add a 1

[nathansav]

So you want to know when the contents changes?

[nathansav]

=if(offset(A2,-1,0)<>a2,1,0)

[alansidman]

In B2, type 1. In B3, type =if(C3=C2,"",1) and copy down.

[HaroonSid]

yes nathansav

when change the contents then put 1 on evry changing

[HaroonSid]

Hello mod alansidman
there is one problem

i want to create serial number till contents change

e.g
c2 = a
c3 = a
c4 = a
c5 = a
c6 = b
c7 = b
c8 = c
c9 = c
c10 = c
c11 = c
c12 = d
c13 = e
c14 = f
c15 = f
.....
c2000 = ?

then i want
B2 = 1
B3 = 2
B4 = 3
B5 = 4
B6 = 1
B7 = 2
B8 = 1
B9 = 2
B10 =3
B11 = 4
B12 = 1
B13 = 1
B14 = 1
B15 = 2

[nathansav]

=if(offset(a2,-1,0)<>a2,1,offset(b2,-1,0)+1)

[HaroonSid]

Perfect

absolutely perfect

thanx nathansav

will add reputation surely

[alansidman]

Alternative solution.

=if(C3=C2,B1+1,1)

In the future, I urge you to explain your issue in full. You may see clearly what is in your worksheet and understand what you want. We can't see it or read your mind. If you don't communicate it clearly to the forum, then responses will be accordingly.