Insert on column change

Tobias Weber · May 19, 2008

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 · May 19, 2008

One way:

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

copy down as far as required.

Tobias Weber · May 19, 2008

JE McGimpsey said:
B1: =COUNTIF($A$1:A1,A1)

With ; instead of , it works fine

Thanks!