排列組合 5數取不重複4數 (12930)

C1:G25{=IFERROR(SMALL(IF(MMULT(ISNUMBER(FIND(TRANSPOSE($A$1:$A$5),ROW($1234:$9876)))*(LEFT(ROW($1234:$9876))-SMALL($A$1:$A$5,COLUMN(A1))=0),{1;1;1;1;1})=4,ROW($1234:$9876)),ROW(A1)),"")



留言