求EXCEL:AB两个字母7位和8位的全排列组合结果.
答案:1 悬赏:80 手机版
解决时间 2021-04-06 08:25
- 提问者网友：山高云阔
- 2021-04-06 00:52
求EXCEL:AB两个字母7位和8位的全排列组合结果.
最佳答案
- 五星知识达人网友：妄饮晩冬酒
- 2021-04-06 02:23
8位，填充到256行：
=SUBSTITUTE(SUBSTITUTE(DEC2BIn(ROW(1:1)-1,8),"0","A"),"1","B")
7位，填充到128行：
=SUBSTITUTE(SUBSTITUTE(DEC2BIn(ROW(1:1)-1,7),"0","A"),"1","B")
=SUBSTITUTE(SUBSTITUTE(DEC2BIn(ROW(1:1)-1,8),"0","A"),"1","B")
7位，填充到128行：
=SUBSTITUTE(SUBSTITUTE(DEC2BIn(ROW(1:1)-1,7),"0","A"),"1","B")
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯