Concatenate unique text values in Excel 2016 (based on criteria in range)

[art_TD]

Hi! Could you please help with such issue?
I am trying to concatenate unique (exact) text values within a range (Name) based on a criteria in another range (Code). No VBA please, just formula(s).

Code	Name	Concat
12345​	Roller	Roller	Roller; idler; sprocket;
12345​	Roller		idler; sprocket;
12345​	Roller		idler; sprocket;
12345​	Roller		idler; sprocket;
12345​	Roller		idler; sprocket;
12345​	Roller		idler; sprocket;
12345​	Roller		idler; sprocket;
12345​	Idler	Idler	Idler; sprocket;
12345​	Idler		sprocket;
12345​	Idler		sprocket;
12345​	Idler		sprocket;
12345​	Idler		sprocket;
12345​	Idler		sprocket;
12345​	Idler		sprocket;
12345​	Idler		sprocket;
12345​	Idler		sprocket;
12345​	Idler		sprocket;
12345​	Sprocket	Sprocket	Sprocket;
12345​	Sprocket
12345​	Sprocket
12345​	Sprocket
12345​	Sprocket
12345​	Sprocket
12345​	Sprocket
12345​	Sprocket
12345​	Sprocket
12345​	Sprocket
54321​	Roller	Roller	Roller; ???; ???
54321​	Idler
54321​	Sprocket

 

[art_TD]

I found out there could be some mistakes (on another longer list of codes and names) and got the formulas as follows.

Cell Formulas
Range	Formula
C2:C31	C2	=IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2)=1,B2,"")
D2:D31	D2	=IF(A3="",C2&";",IF(NOT(A2=A3),"",IF(C2="",D3,C2&"; "&D3)))
E2:E31	E2	=IF(A3="",C2,IF(NOT(A2=A3),"",IF(C2="",E3,C2&IF(E3="","","; ")&E3)))

 

[Sufiyan97]

Can you post post #11 formulas along with data