單格多數字 猜中數 (15100)

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&","))



留言