给出12345,在EXCEL中将这5个数字任意排列成5位数的组合,比如:22351,34312.不能顺序12345,求大神打救

2024-12-19 19:53:43
推荐回答(2个)
回答1:

可以做一个函数来解决。是不是只给出5个数字,我来帮你。

如果有重复值,按f9来刷新。

回答2:

你的问题属于数学上的组合问题。可以借助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