excel任意3位数排列A B123 123345 132213231312321345354435453543534B为A列数的全部排列,求B的公式
来源:学生作业帮助网 编辑:作业帮 时间:2024/11/28 20:05:07
excel任意3位数排列A B123 123345 132213231312321345354435453543534B为A列数的全部排列,求B的公式
excel任意3位数排列
A B
123 123
345 132
213
231
312
321
345
354
435
453
543
534
B为A列数的全部排列,求B的公式
excel任意3位数排列A B123 123345 132213231312321345354435453543534B为A列数的全部排列,求B的公式
=MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MOD(CEILING(ROW(A1)/2,1)-1,3)+1,1)&IF(MOD(ROW(A1),2),LEFT(SUBSTITUTE(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MOD(CEILING(ROW(A1)/2,1)-1,3)+1,1),""))&RIGHT(SUBSTITUTE(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MOD(CEILING(ROW(A1)/2,1)-1,3)+1,1),"")),RIGHT(SUBSTITUTE(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MOD(CEILING(ROW(A1)/2,1)-1,3)+1,1),""))&LEFT(SUBSTITUTE(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MID(INDIRECT("a"&CEILING(ROW(A1)/6,1)),MOD(CEILING(ROW(A1)/2,1)-1,3)+1,1),"")))
我都不知道这是多少个字符,要命,
2007版 可用,试试吧,