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

"chapeau_melon" wrote:

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