求解EXCEL的排列组合的公式
来源:学生作业帮 编辑:搜狗做题网作业帮 分类:综合作业 时间:2024/06/24 08:41:30
求解EXCEL的排列组合的公式
有ABCDE五列数,
A列数为:1,2,3,4,5,6,7,
B列数为:8,9,10,11,12,13,14,
C列数为:15,16,17,18,19,20,21,
D列数为:22,23,24,25,26,27,28,
E列数为:29,30,31,32,33,34,35.
现在需要从任意两列数据中选择5个数出来排列组合,请问如何编写公式?
有ABCDE五列数,
A列数为:1,2,3,4,5,6,7,
B列数为:8,9,10,11,12,13,14,
C列数为:15,16,17,18,19,20,21,
D列数为:22,23,24,25,26,27,28,
E列数为:29,30,31,32,33,34,35.
现在需要从任意两列数据中选择5个数出来排列组合,请问如何编写公式?
![求解EXCEL的排列组合的公式](/uploads/image/z/4074034-58-4.jpg?t=%E6%B1%82%E8%A7%A3EXCEL%E7%9A%84%E6%8E%92%E5%88%97%E7%BB%84%E5%90%88%E7%9A%84%E5%85%AC%E5%BC%8F)
这个是从全部随机选5个数字的公式:
=INDEX($A$1:$E$7,CHOOSE(RAND()*7+1,1,2,3,4,5,6,7),CHOOSE(INT(RAND()*10/2)+1,1,2,3,4,5))
=INDEX($A$1:$E$7,CHOOSE(RAND()*7+1,1,2,3,4,5,6,7),CHOOSE(INT(RAND()*10/2)+1,1,2,3,4,5))