Add suffixes

[ExcelDJO]

Hello All,

This is my first time posting here Any help would be appreciated. Please see attached and let me know if you need more info.

[#2]

@ExcelDJO 

You may try the following formula in C2 and then copy it down.

=IF(D2=INDEX(D:D,MATCH(B2,B:B,0)),B2,B2&"-"&CHAR(MAX(97,IFERROR(CODE(MID(C1,FIND("-",C1)+1,1))+1,0))))

[#3]

Hi Subodh, thank you so much! I am not getting the desired outcome in my file, however I am getting the desired outcome in the file you attached. I have sent you a personal message. Can you please check and help?