編號 不符合 跳過 (10511)

B2{=IF(1-ISERR(FIND("SA",G3)),"",TEXT(F3,"YYMM")&TEXT(SUM((TEXT(F$3:F3,"EM")=TEXT(F3,"EM"))*ISERR(FIND("SA",G$3:G3))),"00"))

另解=IF(LEFT(G3,2)="SA","",TEXT(F3,"YYMM")&TEXT(SUMPRODUCT((TEXT(F$3:F3,"e/mm")=TEXT(F3,"e/mm"))*(LEFT(G$3:G3,2)<>"SA")),"00"))