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.
2 Replies
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?
