D3{=IFERROR(TRIM(MID(SUBSTITUTE(T(OFFSET(A$2,SMALL(IF(LEN(A$3:A$6)-LEN(SUBSTITUTE(A$3:A$6,",",))+1>=COLUMN(A:H),ROW($1:$4)),ROW(A1)),)),",",REPT(" ",19)),RIGHT(SMALL(IF(LEN(A$3:A$6)-LEN(SUBSTITUTE(A$3:A$6,",",))+1>=COLUMN(A:H),ROW($1:$4)/1%+COLUMN(A:H)),ROW(A1)))*19-18,19)),"")
E3{=IF(D3="","",SUM(ISNUMBER(FIND(TRANSPOSE(D$3:D3),A$3:A$6))*ISNUMBER(FIND(D3,A$3:A$6)))*VLOOKUP("*"&D3&"*",A:B,2,))
留言
張貼留言