[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


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

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