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!
Bookmarks