模糊尋找 均出現數字的行數 (13703)

N3=SUMPRODUCT(N(MMULT(1-ISERR(0/(FIND(I3:M3,"@"&$A$3:$E$8)>1)),{1;1;1;1;1})=COUNTIF(I3:M3,"<>")))



留言