Insert on column change

[Tobias Weber]

Hi,
in column A I have:

166
166
189
194
194

Now I want to add a counter in column B like this:

166 1
166 2
189 1
194 1
194 2

How?

 

[JE McGimpsey]

One way:

B1: =COUNTIF($A$1:A1,A1)

copy down as far as required.

 

[Tobias Weber]

B1: =COUNTIF($A$1:A1,A1)

With ; instead of , it works fine Thanks!