G2{=INDEX(C:C,SMALL(IF((MMULT(1-ISERR(FIND(MID(SUBSTITUTE(F2,"*"," "),COLUMN(A:I),1),B$2:B$9&" ")),ROW(1:9)^0)=9)*(LEN(B$2:B$9)=LEN(F2)),ROW($2:$9),99),SUM(N(MATCH(F$2:F2&LEN(F$2:F2),B$2:B$9&LEN(B$2:B$9),)=MATCH(F2&LEN(F2),B$2:B$9&LEN(B$2:B$9),)))))&""
另解{=INDEX(C:C,SMALL(IF(REPLACE(B$2:B$9,2,TEXT(LEN(B$2:B$9)-2,"0;;1"),REPT("*",TEXT(LEN(B$2:B$9)-2,"0;;1")))=F2,ROW($2:$9),99),SUM(N(SUBSTITUTE(F$2:F2,"*","@")=SUBSTITUTE(F2,"*","@")))))&""
留言
張貼留言