判斷 五種狀況 (14961)

I2=IF(D2=D$2,"筛选"&MID("二四五一三",IFERROR(MATCH(SUMPRODUCT((A$2:A$24=A2)*MMULT(N(E$2:F$24=E$2:F$2),{1;10})/COUNTIF(A:A,A$2:A$24)),{0,1,10,11},),5),1),"")



留言