A2:D10{=IF(ISERR(FIND(A$1,$F2)),"",N(SUM(N(COUNTIF($1:$1,TRIM(MID(SUBSTITUTE($F2," ",REPT(" ",19)),ROW($1:$9)*19-18,19)))=0))>0)+COUNT(FIND($A$1:$D$1,$F2)))
E2:E10{=IF(OR(COUNTIF($1:$1,TRIM(MID(SUBSTITUTE($F2," ",REPT(" ",19)),ROW($1:$9)*19-18,19)))=0),IFERROR(LOOKUP(1,0/A2:D2,A2:D2),1),"")
留言
張貼留言