[Solved] For Excel VBA, If B2 value did not change then A2 will keep same, If B2 is changed then A2 will increase by one

by

[ad_1]

Use this formula.

Put your staring number in A1.

Put this in A2:

=IF(B2<>B1,A1+1,A1)

And copy down.

enter image description here

0

[ad_2]

solved For Excel VBA, If B2 value did not change then A2 will keep same, If B2 is changed then A2 will increase by one