问题描述:
求解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个数出来排列组合,请问如何编写公式?
问题解答:
我来补答展开全文阅读