每單一數均可整除該數 (12949)

B2{=SMALL(IF((MMULT(N(FIND(MID(ROW($12:$9876),{1,2,3,4},1),ROW($12:$9876))={1,2,3,4}),{1;1;1;1})=LEN(ROW($12:$9876)))*ISERR(FIND(0,ROW($12:$9876)))*(MMULT(N(IFERROR(MOD(ROW($12:$9876),MID(ROW($12:$9876),{1,2,3,4},1)),1)=0),{1;1;1;1})=LEN(ROW($12:$9876))),ROW($12:$9876)),ROW(A1))



留言