给出12345,在EXCEL中将这5个数字任意排列成5位数的组合，比如：22351,34312.不能顺序12345，求大神打救
展开全部
你的问题属于数学上的组合问题。可以借助vba实现。你的问题答案是：
01,02,03,04,05
01,02,03,05,04
01,02,04,03,05
01,02,04,05,03
01,02,05,03,04
01,02,05,04,03
01,03,02,04,05
01,03,02,05,04
01,03,04,02,05
01,03,04,05,02
01,03,05,02,04
01,03,05,04,02
01,04,02,03,05
01,04,02,05,03
01,04,03,02,05
01,04,03,05,02
01,04,05,02,03
01,04,05,03,02
01,05,02,03,04
01,05,02,04,03
01,05,03,02,04
01,05,03,04,02
01,05,04,02,03
01,05,04,03,02
02,01,03,04,05
02,01,03,05,04
02,01,04,03,05
02,01,04,05,03
02,01,05,03,04
02,01,05,04,03
02,03,01,04,05
02,03,01,05,04
02,03,04,01,05
02,03,04,05,01
02,03,05,01,04
02,03,05,04,01
02,04,01,03,05
02,04,01,05,03
02,04,03,01,05
02,04,03,05,01
02,04,05,01,03
02,04,05,03,01
02,05,01,03,04
02,05,01,04,03
02,05,03,01,04
02,05,03,04,01
02,05,04,01,03
02,05,04,03,01
03,01,02,04,05
03,01,02,05,04
03,01,04,02,05
03,01,04,05,02
03,01,05,02,04
03,01,05,04,02
03,02,01,04,05
03,02,01,05,04
03,02,04,01,05
03,02,04,05,01
03,02,05,01,04
03,02,05,04,01
03,04,01,02,05
03,04,01,05,02
03,04,02,01,05
03,04,02,05,01
03,04,05,01,02
03,04,05,02,01
03,05,01,02,04
03,05,01,04,02
03,05,02,01,04
03,05,02,04,01
03,05,04,01,02
03,05,04,02,01
04,01,02,03,05
04,01,02,05,03
04,01,03,02,05
04,01,03,05,02
04,01,05,02,03
04,01,05,03,02
04,02,01,03,05
04,02,01,05,03
04,02,03,01,05
04,02,03,05,01
04,02,05,01,03
04,02,05,03,01
04,03,01,02,05
04,03,01,05,02
04,03,02,01,05
04,03,02,05,01
04,03,05,01,02
04,03,05,02,01
04,05,01,02,03
04,05,01,03,02
04,05,02,01,03
04,05,02,03,01
04,05,03,01,02
04,05,03,02,01
05,01,02,03,04
05,01,02,04,03
05,01,03,02,04
05,01,03,04,02
05,01,04,02,03
05,01,04,03,02
05,02,01,03,04
05,02,01,04,03
05,02,03,01,04
05,02,03,04,01
05,02,04,01,03
05,02,04,03,01
05,03,01,02,04
05,03,01,04,02
05,03,02,01,04
05,03,02,04,01
05,03,04,01,02
05,03,04,02,01
05,04,01,02,03
05,04,01,03,02
05,04,02,01,03
05,04,02,03,01
05,04,03,01,02
05,04,03,02,01
01,02,03,04,05
01,02,03,05,04
01,02,04,03,05
01,02,04,05,03
01,02,05,03,04
01,02,05,04,03
01,03,02,04,05
01,03,02,05,04
01,03,04,02,05
01,03,04,05,02
01,03,05,02,04
01,03,05,04,02
01,04,02,03,05
01,04,02,05,03
01,04,03,02,05
01,04,03,05,02
01,04,05,02,03
01,04,05,03,02
01,05,02,03,04
01,05,02,04,03
01,05,03,02,04
01,05,03,04,02
01,05,04,02,03
01,05,04,03,02
02,01,03,04,05
02,01,03,05,04
02,01,04,03,05
02,01,04,05,03
02,01,05,03,04
02,01,05,04,03
02,03,01,04,05
02,03,01,05,04
02,03,04,01,05
02,03,04,05,01
02,03,05,01,04
02,03,05,04,01
02,04,01,03,05
02,04,01,05,03
02,04,03,01,05
02,04,03,05,01
02,04,05,01,03
02,04,05,03,01
02,05,01,03,04
02,05,01,04,03
02,05,03,01,04
02,05,03,04,01
02,05,04,01,03
02,05,04,03,01
03,01,02,04,05
03,01,02,05,04
03,01,04,02,05
03,01,04,05,02
03,01,05,02,04
03,01,05,04,02
03,02,01,04,05
03,02,01,05,04
03,02,04,01,05
03,02,04,05,01
03,02,05,01,04
03,02,05,04,01
03,04,01,02,05
03,04,01,05,02
03,04,02,01,05
03,04,02,05,01
03,04,05,01,02
03,04,05,02,01
03,05,01,02,04
03,05,01,04,02
03,05,02,01,04
03,05,02,04,01
03,05,04,01,02
03,05,04,02,01
04,01,02,03,05
04,01,02,05,03
04,01,03,02,05
04,01,03,05,02
04,01,05,02,03
04,01,05,03,02
04,02,01,03,05
04,02,01,05,03
04,02,03,01,05
04,02,03,05,01
04,02,05,01,03
04,02,05,03,01
04,03,01,02,05
04,03,01,05,02
04,03,02,01,05
04,03,02,05,01
04,03,05,01,02
04,03,05,02,01
04,05,01,02,03
04,05,01,03,02
04,05,02,01,03
04,05,02,03,01
04,05,03,01,02
04,05,03,02,01
05,01,02,03,04
05,01,02,04,03
05,01,03,02,04
05,01,03,04,02
05,01,04,02,03
05,01,04,03,02
05,02,01,03,04
05,02,01,04,03
05,02,03,01,04
05,02,03,04,01
05,02,04,01,03
05,02,04,03,01
05,03,01,02,04
05,03,01,04,02
05,03,02,01,04
05,03,02,04,01
05,03,04,01,02
05,03,04,02,01
05,04,01,02,03
05,04,01,03,02
05,04,02,01,03
05,04,02,03,01
05,04,03,01,02
05,04,03,02,01
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
