如何用EXCEL的公式将1到11位数列出8位为一组的全部排列组合,谢谢.

学习 时间:2026-08-24 21:04:29 阅读:2906
如何用EXCEL的公式将1到11位数列出8位为一组的全部排列组合,谢谢.将1,2,3,4,5,6,7,8,9,10,11.组成如:1,2,3,4,5,6,7,8为一组数

最佳回答

雪白的中心

大气的小虾米

2026-08-24 21:04:29

怎么是1到11位数,还能8位为1组?是8个为一组?写公式 =RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)然后下拉复制

最新回答共有2条回答

  • 细心的黄豆
    回复
    2026-08-24 21:04:29

    怎么是1到11位数,还能8位为1组?是8个为一组?写公式 =RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)&","&RANDBETWEEN(1,11)然后下拉复制

上一篇 圣安琪咖啡

下一篇 夏商周三代有哪些人物及故事