可以做一个函数来解决。是不是只给出5个数字,我来帮你。
如果有重复值,按f9来刷新。
你的问题属于数学上的组合问题。可以借助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