202205151601四个數字排列組合 (9955)

I2:L83{=IF(ROW(A1)>PRODUCT(LEN($D$12:$G$12)),"",MID(D$12,MOD(INT((ROW(A1)-1)/PRODUCT(TEXT(LEN(E$12:$H$12),"0;;1")*1)),LEN(D$12))+1,1))

N2:N66{=IFERROR(INDEX(MMULT((0&I$2:L$83)*1,10^{3;2;1;0}),SMALL(IF((0&SUBSTITUTE(MMULT((0&I$2:L$83)*1,10^{3;2;1;0}),I$2:I$83,))*1,ROW($1:$82)),ROW(A1))),"")

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