文本去重复后的数据统计 (10898)

C3:H9=TRIM(MID(SUBSTITUTE(SUBSTITUTE(LEFT($A3,LEN($A3)-1),"(","、"),"、",REPT(" ",99)),COLUMN(A1)*99-98,99))

O3:O9{=IF(OR(MMULT(N(IFERROR(FIND(TRIM(MID(SUBSTITUTE(SUBSTITUTE(LEFT($A3,LEN($A3)-1),"(","、"),"、",REPT(" ",99)),COLUMN(A:E)*99-98,99)),A$2:A2),)>0),{1;1;1;1;1})=5),"",ROW())

以O列輔助 I3:I9=IFERROR(INDEX(A:A,SMALL(O$3:O$9,ROW(A1))),"")

J3:N9{=INDEX($B:$B,SMALL(IF(MMULT(N(IFERROR(FIND(TRIM(MID(SUBSTITUTE(SUBSTITUTE(LEFT($I3,LEN($I3)-1),"(","、"),"、",REPT(" ",99)),COLUMN($A:$E)*99-98,99)),"@"&$A$3:$A$9),)=2),{1;1;1;1;1}),ROW($3:$9),99),COLUMN(A1)))&""

無須O列 以C:H列輔助 I3:I9{=INDEX(A:A,SMALL(IF(MATCH(MMULT(MATCH("*"&C$3:H$9&"*",A:A,),10^(6-ROW($1:$6))),MMULT(MATCH("*"&C$3:H$9&"*",A:A,),10^(6-ROW($1:$6))))=ROW($1:$7),ROW($3:$9),99),ROW(A1)))&""