Creating a unique identifier, Sequence added to specific text

[DOC_D-Rock]

I need to generate a sequencial number after a name is created.
All in the same column. My information comes from multiple columns so I isolated the information to read:
1TR001
1TR002
1FM001
1TR003
1FM002
Given the values: 1 (first day of the week) TR (location) 001 (number of transactions to this location). The Location is 2-3 characters and there are 15 different locations. After 1st transaction is created (for each location) I want the end result to be 1TR001. If a different location is used I need in the same column 1KN001 and so on.
Please help!!

 

[azumi]

Assumed your input code in A2 and down: ie: 1TR, 1FM and so on

Put this in B2 and copied down as necessary:
=A2&TEXT(COUNTIF($A$2:A2,A2),"000")

or see the example
https://www.dropbox.com/s/na9odku94itlxtw/Incremental Numbering.xlsx

Regards
Azumi

 

[DOC_D-Rock]

Assumed your input code in A2 and down: ie: 1TR, 1FM and so on

Put this in B2 and copied down as necessary:
=A2&TEXT(COUNTIF($A$2:A2,A2),"000")

or see the example
https://www.dropbox.com/s/na9odku94itlxtw/Incremental Numbering.xlsx

Regards
Azumi

It works thanks a Million!