求高手帮忙解决一个数学问题,把0 1 3 这三个数字的排列组合列出来,我要的事答案。

举例说明:013000,100310,数字可以重复,也可以只有一个或者两个数字如000001,111111,请帮我列出所有的答案。谢谢!

任意单元格公式:
=IF(OR(COLUMN(A1)>6,ROW(A1)>3^6),"",INT(MOD(INT((ROW(A1)-1)/3^(6-COLUMN(A1))),3)*1.5))
向右向下填充(至出现空格)

-----效果-----
0 0 0 0 0 0
0 0 0 0 0 1
0 0 0 0 0 3
0 0 0 0 1 0
0 0 0 0 1 1
0 0 0 0 1 3
0 0 0 0 3 0
0 0 0 0 3 1
0 0 0 0 3 3
0 0 0 1 0 0
0 0 0 1 0 1
0 0 0 1 0 3
0 0 0 1 1 0
0 0 0 1 1 1
0 0 0 1 1 3
0 0 0 1 3 0
0 0 0 1 3 1
0 0 0 1 3 3
0 0 0 3 0 0
0 0 0 3 0 1
0 0 0 3 0 3
0 0 0 3 1 0
0 0 0 3 1 1
0 0 0 3 1 3
0 0 0 3 3 0
0 0 0 3 3 1
0 0 0 3 3 3
0 0 1 0 0 0
0 0 1 0 0 1
0 0 1 0 0 3
0 0 1 0 1 0
0 0 1 0 1 1
0 0 1 0 1 3
0 0 1 0 3 0
0 0 1 0 3 1
0 0 1 0 3 3
0 0 1 1 0 0
0 0 1 1 0 1
0 0 1 1 0 3
0 0 1 1 1 0
0 0 1 1 1 1
0 0 1 1 1 3
0 0 1 1 3 0
0 0 1 1 3 1
0 0 1 1 3 3
0 0 1 3 0 0
0 0 1 3 0 1
0 0 1 3 0 3
0 0 1 3 1 0
0 0 1 3 1 1
0 0 1 3 1 3
0 0 1 3 3 0
0 0 1 3 3 1
0 0 1 3 3 3
0 0 3 0 0 0
0 0 3 0 0 1
0 0 3 0 0 3
0 0 3 0 1 0
0 0 3 0 1 1
0 0 3 0 1 3
0 0 3 0 3 0
0 0 3 0 3 1
0 0 3 0 3 3
0 0 3 1 0 0
0 0 3 1 0 1
0 0 3 1 0 3
0 0 3 1 1 0
0 0 3 1 1 1
0 0 3 1 1 3
0 0 3 1 3 0
0 0 3 1 3 1
0 0 3 1 3 3
0 0 3 3 0 0
0 0 3 3 0 1
0 0 3 3 0 3
0 0 3 3 1 0
0 0 3 3 1 1
0 0 3 3 1 3
0 0 3 3 3 0
0 0 3 3 3 1
0 0 3 3 3 3
0 1 0 0 0 0
0 1 0 0 0 1
0 1 0 0 0 3
0 1 0 0 1 0
0 1 0 0 1 1
0 1 0 0 1 3
0 1 0 0 3 0
0 1 0 0 3 1
0 1 0 0 3 3
0 1 0 1 0 0
0 1 0 1 0 1
0 1 0 1 0 3
0 1 0 1 1 0
0 1 0 1 1 1
0 1 0 1 1 3
0 1 0 1 3 0
0 1 0 1 3 1
0 1 0 1 3 3
0 1 0 3 0 0
0 1 0 3 0 1
0 1 0 3 0 3
0 1 0 3 1 0
0 1 0 3 1 1
0 1 0 3 1 3
0 1 0 3 3 0
0 1 0 3 3 1
0 1 0 3 3 3
0 1 1 0 0 0
0 1 1 0 0 1
0 1 1 0 0 3
0 1 1 0 1 0
0 1 1 0 1 1
0 1 1 0 1 3
0 1 1 0 3 0
0 1 1 0 3 1
0 1 1 0 3 3
0 1 1 1 0 0
0 1 1 1 0 1
0 1 1 1 0 3
0 1 1 1 1 0
0 1 1 1 1 1
0 1 1 1 1 3
0 1 1 1 3 0
0 1 1 1 3 1
0 1 1 1 3 3
0 1 1 3 0 0
0 1 1 3 0 1
0 1 1 3 0 3
0 1 1 3 1 0
0 1 1 3 1 1
0 1 1 3 1 3
0 1 1 3 3 0
0 1 1 3 3 1
0 1 1 3 3 3
0 1 3 0 0 0
0 1 3 0 0 1
0 1 3 0 0 3
0 1 3 0 1 0
0 1 3 0 1 1
0 1 3 0 1 3
0 1 3 0 3 0
0 1 3 0 3 1
0 1 3 0 3 3
0 1 3 1 0 0
0 1 3 1 0 1
0 1 3 1 0 3
0 1 3 1 1 0
0 1 3 1 1 1
0 1 3 1 1 3
0 1 3 1 3 0
0 1 3 1 3 1
0 1 3 1 3 3
0 1 3 3 0 0
0 1 3 3 0 1
0 1 3 3 0 3
0 1 3 3 1 0
0 1 3 3 1 1
0 1 3 3 1 3
0 1 3 3 3 0
0 1 3 3 3 1
0 1 3 3 3 3
0 3 0 0 0 0
0 3 0 0 0 1
0 3 0 0 0 3
0 3 0 0 1 0
0 3 0 0 1 1
0 3 0 0 1 3
0 3 0 0 3 0
0 3 0 0 3 1
0 3 0 0 3 3
0 3 0 1 0 0
0 3 0 1 0 1
0 3 0 1 0 3
0 3 0 1 1 0
0 3 0 1 1 1
0 3 0 1 1 3
0 3 0 1 3 0
0 3 0 1 3 1
0 3 0 1 3 3
0 3 0 3 0 0
0 3 0 3 0 1
0 3 0 3 0 3
0 3 0 3 1 0
0 3 0 3 1 1
0 3 0 3 1 3
0 3 0 3 3 0
0 3 0 3 3 1
0 3 0 3 3 3
0 3 1 0 0 0
0 3 1 0 0 1
0 3 1 0 0 3
0 3 1 0 1 0
0 3 1 0 1 1
0 3 1 0 1 3
0 3 1 0 3 0
0 3 1 0 3 1
0 3 1 0 3 3
0 3 1 1 0 0
0 3 1 1 0 1
0 3 1 1 0 3
0 3 1 1 1 0
0 3 1 1 1 1
0 3 1 1 1 3
0 3 1 1 3 0
0 3 1 1 3 1
0 3 1 1 3 3
0 3 1 3 0 0
0 3 1 3 0 1
0 3 1 3 0 3
0 3 1 3 1 0
0 3 1 3 1 1
0 3 1 3 1 3
0 3 1 3 3 0
0 3 1 3 3 1
0 3 1 3 3 3
0 3 3 0 0 0
0 3 3 0 0 1
0 3 3 0 0 3
0 3 3 0 1 0
0 3 3 0 1 1
0 3 3 0 1 3
0 3 3 0 3 0
0 3 3 0 3 1
0 3 3 0 3 3
0 3 3 1 0 0
0 3 3 1 0 1
0 3 3 1 0 3
0 3 3 1 1 0
0 3 3 1 1 1
0 3 3 1 1 3
0 3 3 1 3 0
0 3 3 1 3 1
0 3 3 1 3 3
0 3 3 3 0 0
0 3 3 3 0 1
0 3 3 3 0 3
0 3 3 3 1 0
0 3 3 3 1 1
0 3 3 3 1 3
0 3 3 3 3 0
0 3 3 3 3 1
0 3 3 3 3 3
1 0 0 0 0 0
1 0 0 0 0 1
1 0 0 0 0 3
1 0 0 0 1 0
1 0 0 0 1 1
1 0 0 0 1 3
1 0 0 0 3 0
1 0 0 0 3 1
1 0 0 0 3 3
1 0 0 1 0 0
1 0 0 1 0 1
1 0 0 1 0 3
1 0 0 1 1 0
1 0 0 1 1 1
1 0 0 1 1 3
1 0 0 1 3 0
1 0 0 1 3 1
1 0 0 1 3 3
1 0 0 3 0 0
1 0 0 3 0 1
1 0 0 3 0 3
1 0 0 3 1 0
1 0 0 3 1 1
1 0 0 3 1 3
1 0 0 3 3 0
1 0 0 3 3 1
1 0 0 3 3 3
1 0 1 0 0 0
1 0 1 0 0 1
1 0 1 0 0 3
1 0 1 0 1 0
1 0 1 0 1 1
1 0 1 0 1 3
1 0 1 0 3 0
1 0 1 0 3 1
1 0 1 0 3 3
1 0 1 1 0 0
1 0 1 1 0 1
1 0 1 1 0 3
1 0 1 1 1 0
1 0 1 1 1 1
1 0 1 1 1 3
1 0 1 1 3 0
1 0 1 1 3 1
1 0 1 1 3 3
1 0 1 3 0 0
1 0 1 3 0 1
1 0 1 3 0 3
1 0 1 3 1 0
1 0 1 3 1 1
1 0 1 3 1 3
1 0 1 3 3 0
1 0 1 3 3 1
1 0 1 3 3 3
1 0 3 0 0 0
1 0 3 0 0 1
1 0 3 0 0 3
1 0 3 0 1 0
1 0 3 0 1 1
1 0 3 0 1 3
1 0 3 0 3 0
1 0 3 0 3 1
1 0 3 0 3 3
1 0 3 1 0 0
1 0 3 1 0 1
1 0 3 1 0 3
1 0 3 1 1 0
1 0 3 1 1 1
1 0 3 1 1 3
1 0 3 1 3 0
1 0 3 1 3 1
1 0 3 1 3 3
1 0 3 3 0 0
1 0 3 3 0 1
1 0 3 3 0 3
1 0 3 3 1 0
1 0 3 3 1 1
1 0 3 3 1 3
1 0 3 3 3 0
1 0 3 3 3 1
1 0 3 3 3 3
1 1 0 0 0 0
1 1 0 0 0 1
1 1 0 0 0 3
1 1 0 0 1 0
1 1 0 0 1 1
1 1 0 0 1 3
1 1 0 0 3 0
1 1 0 0 3 1
1 1 0 0 3 3
1 1 0 1 0 0
1 1 0 1 0 1
1 1 0 1 0 3
1 1 0 1 1 0
1 1 0 1 1 1
1 1 0 1 1 3
1 1 0 1 3 0
1 1 0 1 3 1
1 1 0 1 3 3
1 1 0 3 0 0
1 1 0 3 0 1
1 1 0 3 0 3
1 1 0 3 1 0
1 1 0 3 1 1
1 1 0 3 1 3
1 1 0 3 3 0
1 1 0 3 3 1
1 1 0 3 3 3
1 1 1 0 0 0
1 1 1 0 0 1
1 1 1 0 0 3
1 1 1 0 1 0
1 1 1 0 1 1
1 1 1 0 1 3
1 1 1 0 3 0
1 1 1 0 3 1
1 1 1 0 3 3
1 1 1 1 0 0
1 1 1 1 0 1
1 1 1 1 0 3
1 1 1 1 1 0
1 1 1 1 1 1
1 1 1 1 1 3
1 1 1 1 3 0
1 1 1 1 3 1
1 1 1 1 3 3
1 1 1 3 0 0
1 1 1 3 0 1
1 1 1 3 0 3
1 1 1 3 1 0
1 1 1 3 1 1
1 1 1 3 1 3
1 1 1 3 3 0
1 1 1 3 3 1
1 1 1 3 3 3
1 1 3 0 0 0
1 1 3 0 0 1
1 1 3 0 0 3
1 1 3 0 1 0
1 1 3 0 1 1
1 1 3 0 1 3
1 1 3 0 3 0
1 1 3 0 3 1
1 1 3 0 3 3
1 1 3 1 0 0
1 1 3 1 0 1
1 1 3 1 0 3
1 1 3 1 1 0
1 1 3 1 1 1
1 1 3 1 1 3
1 1 3 1 3 0
1 1 3 1 3 1
1 1 3 1 3 3
1 1 3 3 0 0
1 1 3 3 0 1
1 1 3 3 0 3
1 1 3 3 1 0
1 1 3 3 1 1
1 1 3 3 1 3
1 1 3 3 3 0
1 1 3 3 3 1
1 1 3 3 3 3
1 3 0 0 0 0
1 3 0 0 0 1
1 3 0 0 0 3
1 3 0 0 1 0
1 3 0 0 1 1
1 3 0 0 1 3
1 3 0 0 3 0
1 3 0 0 3 1
1 3 0 0 3 3
1 3 0 1 0 0
1 3 0 1 0 1
1 3 0 1 0 3
1 3 0 1 1 0
1 3 0 1 1 1
1 3 0 1 1 3
1 3 0 1 3 0
1 3 0 1 3 1
1 3 0 1 3 3
1 3 0 3 0 0
1 3 0 3 0 1
1 3 0 3 0 3
1 3 0 3 1 0
1 3 0 3 1 1
1 3 0 3 1 3
1 3 0 3 3 0
1 3 0 3 3 1
1 3 0 3 3 3
1 3 1 0 0 0
1 3 1 0 0 1
1 3 1 0 0 3
1 3 1 0 1 0
1 3 1 0 1 1
1 3 1 0 1 3
1 3 1 0 3 0
1 3 1 0 3 1
1 3 1 0 3 3
1 3 1 1 0 0
1 3 1 1 0 1
1 3 1 1 0 3
1 3 1 1 1 0
1 3 1 1 1 1
1 3 1 1 1 3
1 3 1 1 3 0
1 3 1 1 3 1
1 3 1 1 3 3
1 3 1 3 0 0
1 3 1 3 0 1
1 3 1 3 0 3
1 3 1 3 1 0
1 3 1 3 1 1
1 3 1 3 1 3
1 3 1 3 3 0
1 3 1 3 3 1
1 3 1 3 3 3
1 3 3 0 0 0
1 3 3 0 0 1
1 3 3 0 0 3
1 3 3 0 1 0
1 3 3 0 1 1
1 3 3 0 1 3
1 3 3 0 3 0
1 3 3 0 3 1
1 3 3 0 3 3
1 3 3 1 0 0
1 3 3 1 0 1
1 3 3 1 0 3
1 3 3 1 1 0
1 3 3 1 1 1
1 3 3 1 1 3
1 3 3 1 3 0
1 3 3 1 3 1
1 3 3 1 3 3
1 3 3 3 0 0
1 3 3 3 0 1
1 3 3 3 0 3
1 3 3 3 1 0
1 3 3 3 1 1
1 3 3 3 1 3
1 3 3 3 3 0
1 3 3 3 3 1
1 3 3 3 3 3
3 0 0 0 0 0
3 0 0 0 0 1
3 0 0 0 0 3
3 0 0 0 1 0
3 0 0 0 1 1
3 0 0 0 1 3
3 0 0 0 3 0
3 0 0 0 3 1
3 0 0 0 3 3
3 0 0 1 0 0
3 0 0 1 0 1
3 0 0 1 0 3
3 0 0 1 1 0
3 0 0 1 1 1
3 0 0 1 1 3
3 0 0 1 3 0
3 0 0 1 3 1
3 0 0 1 3 3
3 0 0 3 0 0
3 0 0 3 0 1
3 0 0 3 0 3
3 0 0 3 1 0
3 0 0 3 1 1
3 0 0 3 1 3
3 0 0 3 3 0
3 0 0 3 3 1
3 0 0 3 3 3
3 0 1 0 0 0
3 0 1 0 0 1
3 0 1 0 0 3
3 0 1 0 1 0
3 0 1 0 1 1
3 0 1 0 1 3
3 0 1 0 3 0
3 0 1 0 3 1
3 0 1 0 3 3
3 0 1 1 0 0
3 0 1 1 0 1
3 0 1 1 0 3
3 0 1 1 1 0
3 0 1 1 1 1
3 0 1 1 1 3
3 0 1 1 3 0
3 0 1 1 3 1
3 0 1 1 3 3
3 0 1 3 0 0
3 0 1 3 0 1
3 0 1 3 0 3
3 0 1 3 1 0
3 0 1 3 1 1
3 0 1 3 1 3
3 0 1 3 3 0
3 0 1 3 3 1
3 0 1 3 3 3
3 0 3 0 0 0
3 0 3 0 0 1
3 0 3 0 0 3
3 0 3 0 1 0
3 0 3 0 1 1
3 0 3 0 1 3
3 0 3 0 3 0
3 0 3 0 3 1
3 0 3 0 3 3
3 0 3 1 0 0
3 0 3 1 0 1
3 0 3 1 0 3
3 0 3 1 1 0
3 0 3 1 1 1
3 0 3 1 1 3
3 0 3 1 3 0
3 0 3 1 3 1
3 0 3 1 3 3
3 0 3 3 0 0
3 0 3 3 0 1
3 0 3 3 0 3
3 0 3 3 1 0
3 0 3 3 1 1
3 0 3 3 1 3
3 0 3 3 3 0
3 0 3 3 3 1
3 0 3 3 3 3
3 1 0 0 0 0
3 1 0 0 0 1
3 1 0 0 0 3
3 1 0 0 1 0
3 1 0 0 1 1
3 1 0 0 1 3
3 1 0 0 3 0
3 1 0 0 3 1
3 1 0 0 3 3
3 1 0 1 0 0
3 1 0 1 0 1
3 1 0 1 0 3
3 1 0 1 1 0
3 1 0 1 1 1
3 1 0 1 1 3
3 1 0 1 3 0
3 1 0 1 3 1
3 1 0 1 3 3
3 1 0 3 0 0
3 1 0 3 0 1
3 1 0 3 0 3
3 1 0 3 1 0
3 1 0 3 1 1
3 1 0 3 1 3
3 1 0 3 3 0
3 1 0 3 3 1
3 1 0 3 3 3
3 1 1 0 0 0
3 1 1 0 0 1
3 1 1 0 0 3
3 1 1 0 1 0
3 1 1 0 1 1
3 1 1 0 1 3
3 1 1 0 3 0
3 1 1 0 3 1
3 1 1 0 3 3
3 1 1 1 0 0
3 1 1 1 0 1
3 1 1 1 0 3
3 1 1 1 1 0
3 1 1 1 1 1
3 1 1 1 1 3
3 1 1 1 3 0
3 1 1 1 3 1
3 1 1 1 3 3
3 1 1 3 0 0
3 1 1 3 0 1
3 1 1 3 0 3
3 1 1 3 1 0
3 1 1 3 1 1
3 1 1 3 1 3
3 1 1 3 3 0
3 1 1 3 3 1
3 1 1 3 3 3
3 1 3 0 0 0
3 1 3 0 0 1
3 1 3 0 0 3
3 1 3 0 1 0
3 1 3 0 1 1
3 1 3 0 1 3
3 1 3 0 3 0
3 1 3 0 3 1
3 1 3 0 3 3
3 1 3 1 0 0
3 1 3 1 0 1
3 1 3 1 0 3
3 1 3 1 1 0
3 1 3 1 1 1
3 1 3 1 1 3
3 1 3 1 3 0
3 1 3 1 3 1
3 1 3 1 3 3
3 1 3 3 0 0
3 1 3 3 0 1
3 1 3 3 0 3
3 1 3 3 1 0
3 1 3 3 1 1
3 1 3 3 1 3
3 1 3 3 3 0
3 1 3 3 3 1
3 1 3 3 3 3
3 3 0 0 0 0
3 3 0 0 0 1
3 3 0 0 0 3
3 3 0 0 1 0
3 3 0 0 1 1
3 3 0 0 1 3
3 3 0 0 3 0
3 3 0 0 3 1
3 3 0 0 3 3
3 3 0 1 0 0
3 3 0 1 0 1
3 3 0 1 0 3
3 3 0 1 1 0
3 3 0 1 1 1
3 3 0 1 1 3
3 3 0 1 3 0
3 3 0 1 3 1
3 3 0 1 3 3
3 3 0 3 0 0
3 3 0 3 0 1
3 3 0 3 0 3
3 3 0 3 1 0
3 3 0 3 1 1
3 3 0 3 1 3
3 3 0 3 3 0
3 3 0 3 3 1
3 3 0 3 3 3
3 3 1 0 0 0
3 3 1 0 0 1
3 3 1 0 0 3
3 3 1 0 1 0
3 3 1 0 1 1
3 3 1 0 1 3
3 3 1 0 3 0
3 3 1 0 3 1
3 3 1 0 3 3
3 3 1 1 0 0
3 3 1 1 0 1
3 3 1 1 0 3
3 3 1 1 1 0
3 3 1 1 1 1
3 3 1 1 1 3
3 3 1 1 3 0
3 3 1 1 3 1
3 3 1 1 3 3
3 3 1 3 0 0
3 3 1 3 0 1
3 3 1 3 0 3
3 3 1 3 1 0
3 3 1 3 1 1
3 3 1 3 1 3
3 3 1 3 3 0
3 3 1 3 3 1
3 3 1 3 3 3
3 3 3 0 0 0
3 3 3 0 0 1
3 3 3 0 0 3
3 3 3 0 1 0
3 3 3 0 1 1
3 3 3 0 1 3
3 3 3 0 3 0
3 3 3 0 3 1
3 3 3 0 3 3
3 3 3 1 0 0
3 3 3 1 0 1
3 3 3 1 0 3
3 3 3 1 1 0
3 3 3 1 1 1
3 3 3 1 1 3
3 3 3 1 3 0
3 3 3 1 3 1
3 3 3 1 3 3
3 3 3 3 0 0
3 3 3 3 0 1
3 3 3 3 0 3
3 3 3 3 1 0
3 3 3 3 1 1
3 3 3 3 1 3
3 3 3 3 3 0
3 3 3 3 3 1
3 3 3 3 3 3
温馨提示:答案为网友推荐,仅供参考
第1个回答  2012-05-19
如果可以重复使用,又没有限制位数,这样的组合有无数个。追问

我知道这样的答案很多,但不是无数个,我只想要组个成6为数字的,肯定有答案的,只想求EXCEL高手帮我一下

第2个回答  2012-05-19
组成6位数字的一共有729种啊,自己慢慢列吧
第3个回答  2012-05-19
木有位数限制吗???筒靴----

相关了解……

你可能感兴趣的内容

本站内容来自于网友发表,不代表本站立场,仅表示其个人看法,不对其真实性、正确性、有效性作任何的担保
相关事宜请发邮件给我们
© 非常风气网