[算表] M取N的不重覆排列組合
軟體:EXCEL
版本:2003
請問是否可用EXCEL做出不重覆的排列組合列表
例如:
01~36 共36個數字 一組取6個數字 組內數字不可重複
組與組也不可重複選取同樣的六個數字(順序不同也不可以)
EX
01 03 05 07 09 15
15 03 01 09 07 05 這樣就不可以
麻煩各位解答
謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 36.238.92.202
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1447231913.A.E27.html
→
11/11 17:33, , 1F
11/11 17:33, 1F
→
11/11 17:47, , 2F
11/11 17:47, 2F
→
11/11 18:04, , 3F
11/11 18:04, 3F
→
11/11 18:04, , 4F
11/11 18:04, 4F
→
11/11 18:04, , 5F
11/11 18:04, 5F
→
11/11 18:05, , 6F
11/11 18:05, 6F
→
11/11 18:05, , 7F
11/11 18:05, 7F
→
11/11 18:05, , 8F
11/11 18:05, 8F
→
11/11 18:05, , 9F
11/11 18:05, 9F
→
11/11 18:13, , 10F
11/11 18:13, 10F
→
11/11 19:10, , 11F
11/11 19:10, 11F
→
11/11 19:22, , 12F
11/11 19:22, 12F
推
11/12 14:19, , 13F
11/12 14:19, 13F
→
11/12 14:20, , 14F
11/12 14:20, 14F
→
11/12 16:00, , 15F
11/12 16:00, 15F
→
11/12 16:01, , 16F
11/12 16:01, 16F
→
11/12 16:02, , 17F
11/12 16:02, 17F
推
11/12 16:50, , 18F
11/12 16:50, 18F
→
11/12 16:50, , 19F
11/12 16:50, 19F
→
11/12 16:52, , 20F
11/12 16:52, 20F
→
11/12 16:52, , 21F
11/12 16:52, 21F
→
11/12 17:09, , 22F
11/12 17:09, 22F
推
11/12 17:45, , 23F
11/12 17:45, 23F
→
11/12 23:38, , 24F
11/12 23:38, 24F
→
11/13 00:02, , 25F
11/13 00:02, 25F
→
11/13 00:39, , 26F
11/13 00:39, 26F
→
11/13 00:40, , 27F
11/13 00:40, 27F
→
11/13 00:40, , 28F
11/13 00:40, 28F
推
11/14 23:55, , 29F
11/14 23:55, 29F
Office 近期熱門文章
PTT數位生活區 即時熱門文章