Excel中如何用aaaabbbb随机最大程度组组啊，如aabbabab，babababa等等？

如题所述

举报该文章

相关建议 2020-07-31

参考下面处理

Excel怎样处理排列组合列表

温馨提示：内容为网友见解，仅供参考

当前网址：https://aolonic.com/aa/4a3n35ad43431ndgk1.html

其他看法

第1个回答 2020-07-29

就70个，给你。
aaaabbbb
aaababbb
aaabbabb
aaabbbab
aaabbbba
aabaabbb
aabababb
aababbab
aababbba
aabbaabb
aabbabab
aabbabba
aabbbaab
aabbbaba
aabbbbaa
abaaabbb
abaababb
abaabbab
abaabbba
ababaabb
abababab
abababba
ababbaab
ababbaba
ababbbaa
abbaaabb
abbaabab
abbaabba
abbabaab
abbababa
abbabbaa
abbbaaab
abbbaaba
abbbabaa
abbbbaaa
baaaabbb
baaababb
baaabbab
baaabbba
baabaabb
baababab
baababba
baabbaab
baabbaba
baabbbaa
babaaabb
babaabab
babaabba
bababaab
babababa
bababbaa
babbaaab
babbaaba
babbabaa
babbbaaa
bbaaaabb
bbaaabab
bbaaabba
bbaabaab
bbaababa
bbaabbaa
bbabaaab
bbabaaba
bbababaa
bbabbaaa
bbbaaaab
bbbaaaba
bbbaabaa
bbbabaaa
bbbbaaaa

第2个回答 2020-07-29

你是要随机出现1组,还是所有组随机排列

Excel中如何用aaaabbbb随机最大程度组组啊,如aabbabab,babababa...
Excel怎样处理排列组合列表

怎么用aaabbb随机组成6字最多的组合?如:aabbab,baabba
aaaabbbb:8!\/4!\/4!=40320\/24\/24=70（种）n个a和n个b:(2n)!\/n!\/n!