Concatenate if already exist in Columns...

I will like to add a letter "B" if there is already one. Let me explain in column A there is a list of companies I will like that in column C check for the whole column and if there is that company again then add the letter B at the end if not just paste the name of the company.column.PNG

I used =IF(A2=A:A,CONCATENATE(A2,"b")) but with this always put the "b" and I only want it if there is the company more than one.

Hello edvavi, and welcome to the forum.

Try:

=A2&IF(COUNTIF(A$2:A2,A2)>1,"b","")

Thanks for your quick and excellent response. That work for me.

Glad to hear it. You're quite welcome. Please remember to mark your thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save