auto increase number if number is double or more

[chapeau_melon]

This is what I'dd like to do

1000
1000
2000
3000
3000
3000

have to become

1000 1
1000 2
2000 1
3000 1
3000 2
3000 3
etc...

Kind regards

 

[David Biddulph]

In B2, =IF(A2=A1,B1+1,1) , and copy down

 

[chapeau_melon]

Excellent thank you very much for the quick reply

 

[Kevin Vaughn]

Excellent thank you very much for the quick reply

A formula like this:
=COUNTIF($A$1:A1,A1)
might also work for you, although if your data was not sorted, ie
something like this:
1000
1000
2000
3000
3000
2000
3000
The 2nd occurrence of 2000 might not give you the answer you wanted
(but then again, it might depending on your needs.)

 

[Guest]

Not sure whether you want the 1,2 etc in separate column:

in B1 and copy down

=COUNTIF($A$1:A1,A1) will get the 1,2, 3 etc

this will combine in a single column :

=A1 &" "&COUNTIF($A$1:A1,A1)

HTH