D2=SUMPRODUCT(N(MMULT(1-ISERR(FIND(","&ROW($1:$99)&",",","&B2:C2&",")),{1;1})=2))
另解{=COUNT(FIND(","&TRIM(MID(SUBSTITUTE(C2,",",REPT(" ",19)),ROW($1:$6)*19-18,19))&",",","&B2&","))
另解{=COUNT(FIND(","&ROW($1:$99)&",",","&B2&",")*FIND(","&ROW($1:$99)&",",","&C2&","))
留言
張貼留言