使用Excel排列组合,假如我想把0-9这十个数中取5个,总共126种情况都找出

使用Excel排列组合,假如我想把0-9这十个数中取5个,总共126种情况都找出来,有相应的公式吗?

不计顺序有252种吧

0, 1, 2, 3, 4

0, 1, 2, 3, 5

0, 1, 2, 3, 6

0, 1, 2, 3, 7

0, 1, 2, 3, 8

0, 1, 2, 3, 9

0, 1, 2, 4, 5

0, 1, 2, 4, 6

0, 1, 2, 4, 7

0, 1, 2, 4, 8

0, 1, 2, 4, 9

0, 1, 2, 5, 6

0, 1, 2, 5, 7

0, 1, 2, 5, 8

0, 1, 2, 5, 9

0, 1, 2, 6, 7

0, 1, 2, 6, 8

0, 1, 2, 6, 9

0, 1, 2, 7, 8

0, 1, 2, 7, 9

0, 1, 2, 8, 9

0, 1, 3, 4, 5

0, 1, 3, 4, 6

0, 1, 3, 4, 7

0, 1, 3, 4, 8

0, 1, 3, 4, 9

0, 1, 3, 5, 6

0, 1, 3, 5, 7

0, 1, 3, 5, 8

0, 1, 3, 5, 9

0, 1, 3, 6, 7

0, 1, 3, 6, 8

0, 1, 3, 6, 9

0, 1, 3, 7, 8

0, 1, 3, 7, 9

0, 1, 3, 8, 9

0, 1, 4, 5, 6

0, 1, 4, 5, 7

0, 1, 4, 5, 8

0, 1, 4, 5, 9

0, 1, 4, 6, 7

0, 1, 4, 6, 8

0, 1, 4, 6, 9

0, 1, 4, 7, 8

0, 1, 4, 7, 9

0, 1, 4, 8, 9

0, 1, 5, 6, 7

0, 1, 5, 6, 8

0, 1, 5, 6, 9

0, 1, 5, 7, 8

0, 1, 5, 7, 9

0, 1, 5, 8, 9

0, 1, 6, 7, 8

0, 1, 6, 7, 9

0, 1, 6, 8, 9

0, 1, 7, 8, 9

0, 2, 3, 4, 5

0, 2, 3, 4, 6

0, 2, 3, 4, 7

0, 2, 3, 4, 8

0, 2, 3, 4, 9

0, 2, 3, 5, 6

0, 2, 3, 5, 7

0, 2, 3, 5, 8

0, 2, 3, 5, 9

0, 2, 3, 6, 7

0, 2, 3, 6, 8

0, 2, 3, 6, 9

0, 2, 3, 7, 8

0, 2, 3, 7, 9

0, 2, 3, 8, 9

0, 2, 4, 5, 6

0, 2, 4, 5, 7

0, 2, 4, 5, 8

0, 2, 4, 5, 9

0, 2, 4, 6, 7

0, 2, 4, 6, 8

0, 2, 4, 6, 9

0, 2, 4, 7, 8

0, 2, 4, 7, 9

0, 2, 4, 8, 9

0, 2, 5, 6, 7

0, 2, 5, 6, 8

0, 2, 5, 6, 9

0, 2, 5, 7, 8

0, 2, 5, 7, 9

0, 2, 5, 8, 9

0, 2, 6, 7, 8

0, 2, 6, 7, 9

0, 2, 6, 8, 9

0, 2, 7, 8, 9

0, 3, 4, 5, 6

0, 3, 4, 5, 7

0, 3, 4, 5, 8

0, 3, 4, 5, 9

0, 3, 4, 6, 7

0, 3, 4, 6, 8

0, 3, 4, 6, 9

0, 3, 4, 7, 8

0, 3, 4, 7, 9

0, 3, 4, 8, 9

0, 3, 5, 6, 7

0, 3, 5, 6, 8

0, 3, 5, 6, 9

0, 3, 5, 7, 8

0, 3, 5, 7, 9

0, 3, 5, 8, 9

0, 3, 6, 7, 8

0, 3, 6, 7, 9

0, 3, 6, 8, 9

0, 3, 7, 8, 9

0, 4, 5, 6, 7

0, 4, 5, 6, 8

0, 4, 5, 6, 9

0, 4, 5, 7, 8

0, 4, 5, 7, 9

0, 4, 5, 8, 9

0, 4, 6, 7, 8

0, 4, 6, 7, 9

0, 4, 6, 8, 9

0, 4, 7, 8, 9

0, 5, 6, 7, 8

0, 5, 6, 7, 9

0, 5, 6, 8, 9

0, 5, 7, 8, 9

0, 6, 7, 8, 9

1, 2, 3, 4, 5

1, 2, 3, 4, 6

1, 2, 3, 4, 7

1, 2, 3, 4, 8

1, 2, 3, 4, 9

1, 2, 3, 5, 6

1, 2, 3, 5, 7

1, 2, 3, 5, 8

1, 2, 3, 5, 9

1, 2, 3, 6, 7

1, 2, 3, 6, 8

1, 2, 3, 6, 9

1, 2, 3, 7, 8

1, 2, 3, 7, 9

1, 2, 3, 8, 9

1, 2, 4, 5, 6

1, 2, 4, 5, 7

1, 2, 4, 5, 8

1, 2, 4, 5, 9

1, 2, 4, 6, 7

1, 2, 4, 6, 8

1, 2, 4, 6, 9

1, 2, 4, 7, 8

1, 2, 4, 7, 9

1, 2, 4, 8, 9

1, 2, 5, 6, 7

1, 2, 5, 6, 8

1, 2, 5, 6, 9

1, 2, 5, 7, 8

1, 2, 5, 7, 9

1, 2, 5, 8, 9

1, 2, 6, 7, 8

1, 2, 6, 7, 9

1, 2, 6, 8, 9

1, 2, 7, 8, 9

1, 3, 4, 5, 6

1, 3, 4, 5, 7

1, 3, 4, 5, 8

1, 3, 4, 5, 9

1, 3, 4, 6, 7

1, 3, 4, 6, 8

1, 3, 4, 6, 9

1, 3, 4, 7, 8

1, 3, 4, 7, 9

1, 3, 4, 8, 9

1, 3, 5, 6, 7

1, 3, 5, 6, 8

1, 3, 5, 6, 9

1, 3, 5, 7, 8

1, 3, 5, 7, 9

1, 3, 5, 8, 9

1, 3, 6, 7, 8

1, 3, 6, 7, 9

1, 3, 6, 8, 9

1, 3, 7, 8, 9

1, 4, 5, 6, 7

1, 4, 5, 6, 8

1, 4, 5, 6, 9

1, 4, 5, 7, 8

1, 4, 5, 7, 9

1, 4, 5, 8, 9

1, 4, 6, 7, 8

1, 4, 6, 7, 9

1, 4, 6, 8, 9

1, 4, 7, 8, 9

1, 5, 6, 7, 8

1, 5, 6, 7, 9

1, 5, 6, 8, 9

1, 5, 7, 8, 9

1, 6, 7, 8, 9

2, 3, 4, 5, 6

2, 3, 4, 5, 7

2, 3, 4, 5, 8

2, 3, 4, 5, 9

2, 3, 4, 6, 7

2, 3, 4, 6, 8

2, 3, 4, 6, 9

2, 3, 4, 7, 8

2, 3, 4, 7, 9

2, 3, 4, 8, 9

2, 3, 5, 6, 7

2, 3, 5, 6, 8

2, 3, 5, 6, 9

2, 3, 5, 7, 8

2, 3, 5, 7, 9

2, 3, 5, 8, 9

2, 3, 6, 7, 8

2, 3, 6, 7, 9

2, 3, 6, 8, 9

2, 3, 7, 8, 9

2, 4, 5, 6, 7

2, 4, 5, 6, 8

2, 4, 5, 6, 9

2, 4, 5, 7, 8

2, 4, 5, 7, 9

2, 4, 5, 8, 9

2, 4, 6, 7, 8

2, 4, 6, 7, 9

2, 4, 6, 8, 9

2, 4, 7, 8, 9

2, 5, 6, 7, 8

2, 5, 6, 7, 9

2, 5, 6, 8, 9

2, 5, 7, 8, 9

2, 6, 7, 8, 9

3, 4, 5, 6, 7

3, 4, 5, 6, 8

3, 4, 5, 6, 9

3, 4, 5, 7, 8

3, 4, 5, 7, 9

3, 4, 5, 8, 9

3, 4, 6, 7, 8

3, 4, 6, 7, 9

3, 4, 6, 8, 9

3, 4, 7, 8, 9

3, 5, 6, 7, 8

3, 5, 6, 7, 9

3, 5, 6, 8, 9

3, 5, 7, 8, 9

3, 6, 7, 8, 9

4, 5, 6, 7, 8

4, 5, 6, 7, 9

4, 5, 6, 8, 9

4, 5, 7, 8, 9

4, 6, 7, 8, 9

5, 6, 7, 8, 9
温馨提示:答案为网友推荐,仅供参考
第1个回答  2016-06-25
没办法用公式,只能用VBA,总共252种排列
Sub 排列()
i = 1
For a = 0 To 9
For b = a + 1 To 9
For c = b + 1 To 9
For d = c + 1 To 9
For e = d + 1 To 9
Cells(i, 1).Value = "'" & a & b & c & d & e
i = i + 1
Next
Next
Next
Next
Next
End Sub本回答被提问者和网友采纳
第2个回答  2016-06-25
0-9任意取5个,好象不止126种情况吧。你是怎么算出来的,
相似回答