auto increase number if number is double or more

C

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
 
K

Kevin Vaughn

Excellent thank you very much for the quick reply
Click to expand...

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.)
 
T

Toppers

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
 
Top