Incrementing the numbers

[Hmuna]

Learning from your youtube number incrementing tutorial, i have a problem and hope you guys help me.

[/URL] Uploaded with ImageShack.us[/IMG]

I want to increment the number of the ID only if the CODE in "C Cell" is '1' (one), like in the picture. Before, i use "=ROWS(IF(A12>1,A$2:A12,A12))" but it only gives a continuous number, hope you can help me.

Thanks in advance

 

[CWatts]

Put this in A3 and copy down:

=IF(C3=1,A2+1,A2)

 

[njimack]

Not sure why you're using ROWS. Isn't it simply =A2+IF(C3=1,1,0)

 

[awsumchillicrab]

=IF(C3=1, A2+1, A2)

You'll manually input 150200001 into cell A2, then put the formula from A3 onwards.

If you don't want manual input for A2,

=IF(ISERROR(IF(C2=1, A1+1, A1)),150200001,IF(C2=1, A1+1, A1)).

 

[Hmuna]

wow........thanks a lot.....you guys are awesome......hope i can do something for you. THANKS AGAIN....MAY GOD BLESS YOU ALL.