紧急!加分!怎样把excel里面的300多个数据分成5个一组,然后选出5个中数...答:假设在A 1,2,3,4,5,6,7,8,9,10,11,12列数... B1输入函数公式 = OFFSET($ A $ 1,(COLUMN()-2)* 5 + ROW()-1,0,1,1)在B列C 6,7,8,9,10,1,2,3,4,5,列等 是不是你想要什么?
excel中如何把0-9十个数字分别以5个组成一组,例如12345,23456,34567...答:=INDEX($A$1:$J$1,1,ROUND(RANDBETWEEN(1,10),1))&INDEX($A$1:$J$1,1,ROUND(RANDBETWEEN(1,10),1))&INDEX($A$1:$J$1,1,ROUND(RANDBETWEEN(1,10),1))&INDEX($A$1:$J$1,1,ROUND(RANDBETWEEN(1,10),1))&INDEX($A$1:$J$1,1,ROUND(RANDBETWEEN(1,10),1))下拉 ...