202111291400取出均含三數字 (9193)

G7 右拉 下拉 {=IFERROR(SMALL(IF(1-ISERR(FIND($C7,$G$3:$P$5)*FIND($D7,$G$3:$P$5)*FIND($E7,$G$3:$P$5)),$G$3:$P$5),COLUMN(A1)),"")

另解 {=IFERROR(SMALL(IF(MMULT(N(LEN(SUBSTITUTE(SMALL($G$3:$P$5,ROW($1:$30)),$C7:$E7,))=3),{1;1;1})>2,SMALL($G$3:$P$5,ROW($1:$30))),COLUMN(A1)),"")

另解 {=IFERROR(SMALL(IF(LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($G$3:$P$5,$C7,),$D7,),$E7,))=4-SUM(1/COUNTIF($C7:$E7,$C7:$E7)),$G$3:$P$5),COLUMN(A1)),"")

另解 {=IFERROR(SMALL(IF(MMULT(1-ISERR(FIND($C7:$E7,SMALL($G$3:$P$5,ROW($1:$30)))),{1;1;1})>2,SMALL($G$3:$P$5,ROW($1:$30))),COLUMN(A1)),"")

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank