Forum Discussion
Add suffixes
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.
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))))
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?