Adding a number sequence to the end of a cells value.

[danbates]

Hi,

I have a list of over 250 names.

I have found a formula that had created another list of just their initials.

What I would like, if possible is to be able to add a 1, 2, 3 and so on to the initials.

For example, if I had:
AA
AA
AA
BB
CC
CC
CC
CC
DD
DD

I would like to be able to change them to the following:
AA1
AA2
AA3
BB1
CC1
CC2
CC3
CC4
DD1
DD2

Any help would be appreciated.

Thanks

Dan

 

[Fluff]

How about

+Fluff New.xlsm
	G	H
1
2	AA	AA1
3	AA	AA2
4	AA	AA3
5	BB	BB1
6	CC	CC1
7	CC	CC2
8	CC	CC3
9	CC	CC4
10	DD	DD1
11	DD	DD2
Main

Cell Formulas
Range	Formula
H2:H11	H2	=G2&COUNTIFS(G$2:G2,G2)

 

[danbates]

Hi Fluff,

Perfect yet again. Thank you.

 

[Fluff]

Glad to help & thanks for the feedback.