Creating. Excel Formula

[tgukltd]

Hi

I wonder if someone can help me, I am looking to create a formula where excel is able to search column A, and if it finds a duplicate it will add PT01 at the end. If it finds a further duplicate with the same value it will add PT02, and so forth up until PT15.

I have attached an example.

Any help would be appreciated. Thank you!

[Pete_UK]

A picture is not much use - why not attach the Excel workbook?

Try this in C2:

=IF(A2="","",A2&" - PT"&TEXT(COUNTIF(A$2:A2,A2),"00"))

Then copy down.

Hope this helps.

Pete

[alansidman]

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

Use concise, accurate thread titles.
Your post title should describe your problem, not your anticipated solution.
Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

When you have changed the title, please also give full details of the problem in the body of your post - nobody should have to open an attachment to find out what you want.