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

学习 时间:2026-03-30 07:19:39 阅读:3506
如何用EXCEL的公式将1到11位数列出8位为一组的全部排列组合,谢谢.将1,2,3,4,5,6,7,8,9,10,11.组成如:1,2,3,4,5,6,7,8为一组数

最佳回答

孝顺的野狼

忐忑的滑板

2026-03-30 07:19:39

怎么是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-03-30 07:19:39

    怎么是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)然后下拉复制

上一篇 圣安琪咖啡

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