202205161404五位數取四位組合 (9959)

D1 下拉{=IFERROR(SMALL(IF(MMULT(LEN(SUBSTITUTE(B$2,MID(ROW($1234:$9876),{1,2,3,4},1),))*(FIND(MID(ROW($1234:$9876),{1,2,3,4},1),ROW($1234:$9876))={1,2,3,4}),{1;1;1;1})=16,ROW($1234:$9876)),ROW(A1)),"")

另解{=IFERROR(SMALL(IF(MMULT(N(LEN(SUBSTITUTE(B$2,MID(IF(MMULT(N(LEN(SUBSTITUTE(ROW($1234:$9876),MID(ROW($1234:$9876),{1,2,3,4},1),))<3),{1;1;1;1})=0,ROW($1234:$9876)),{1,2,3,4},1),))=4),{1;1;1;1})=4,ROW($1234:$9876)),ROW(A1)),"")

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