Adding number to the end of alphanumeric cell values in a column

[mike_m1]

Does anyone know a good way to add numbers to the end of specific values in a column for example:

foot1six
foot1six
foot2six
foot4six
foot3six
foot2six
foot3six
foot4six
foot1six
foot2six
foot3six
foot1six
foot1six

How would I add a consecutive number 1,2,3 after the same values in the example row to create the following:

foot1six1
foot1six2
foot2six1
foot4six1
foot3six1
foot2six2
foot3six2
foot4six2
foot1six3
foot2six3
foot3six3
foot1six4
foot1six5

Mike

[NBVC]

Try:

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

copied down where A1 contains first item.

[mike_m1]

NBVC, complete and utter genius, properly impressed, have been hitting my head against the desk trying to get to the bottom of this one and it's answered in minutes on here, thank you very much.

Mike