二列含二字符 提出 (10081)


G2{=INDEX(C:C,SMALL(IF(MMULT(1-ISERR(FIND({"P","a0"},A$2:B$22)),{1;1})=2,ROW($2:$22),99),ROW(A1)))&""


另解{=INDEX(C:C,SMALL(IF(1-ISERR(FIND("P",A$2:A$22)+FIND("a0",B$2:B$22)),ROW($2:$22),99),ROW(A1)))&""


留言