How to count same values from 1 Cell

[mando_R3GTR]

Hi,

I have a file where in a certain tab I have a dropdown list with resources (cell J2) multiple selections and doubles are possible (picture 1), in another tab I need to exclude the doubles but result them in a count (%) when doubles occur and singles need to be added with a comma in between (picture 2)

 

[JvdV]

Book1
	A	B
1	xxxx,xxxx,xxxx,aaa,bbb	xxxx[300%],aaa,bbb
Sheet7

Cell Formulas
Range	Formula
B1	B1	=LET(x,TEXTSPLIT(A1,","),TEXTJOIN(",",,MAP(UNIQUE(x,1),LAMBDA(y,LET(z,SUM(--(x=y)),IF(z=1,y,y&"["&z*100&"%]"))))))

 

[mando_R3GTR]

Book1
	A	B
1	xxxx,xxxx,xxxx,aaa,bbb	xxxx[300%],aaa,bbb
Sheet7

Cell Formulas
Range	Formula
B1	B1	=LET(x,TEXTSPLIT(A1,","),TEXTJOIN(",",,MAP(UNIQUE(x,1),LAMBDA(y,LET(z,SUM(--(x=y)),IF(z=1,y,y&"["&z*100&"%]"))))))

thanks a lot, works perfectly