C2:C6{=SUBSTITUTE(INDEX(A:A,SMALL(IF(1-ISERR(FIND(C$2,A$3:A$12)),ROW($3:$12),99),ROW(A1)))&"",C$2&":",)
D2:F6{=IF($C3="","",IFERROR(SUBSTITUTE(LOOKUP(1,0/FIND($C3,LOOKUP(ROW(3:12),ROW(3:12)/ISNUMBER(FIND($C$2,$A$3:$A$12)),$A$3:$A$12))/FIND(D$2,$A$3:$A$12),$A$3:$A$12),D$2&":",),""))
留言
張貼留言