excel中几组数据如何生存排列组合
发布网友
发布时间:2022-04-20 14:17
我来回答
共2个回答
热心网友
时间:2022-06-17 18:51
假定你现在有A列B列C列D列E列共5列数据,每列数据个数不定,生成所有排列组合的公式
=INDIRECT("A"&INT(MOD(ROW(A1)-1,COUNTA(A:A)*COUNTA(B:B)*COUNTA(C:C)*COUNTA(D:D)*COUNTA(E:E))/(COUNTA(B:B)*COUNTA(C:C)*COUNTA(D:D)*COUNTA(E:E)))+1)&INDIRECT("B"&INT(MOD(ROW(A1)-1,COUNTA(B:B)*COUNTA(C:C)*COUNTA(D:D)*COUNTA(E:E))/(COUNTA(C:C)*COUNTA(D:D)*COUNTA(E:E)))+1)&INDIRECT("C"&INT(MOD(ROW(A1)-1,COUNTA(C:C)*COUNTA(D:D)*COUNTA(E:E))/(COUNTA(D:D)*COUNTA(E:E)))+1)&INDIRECT("D"&INT(MOD(ROW(A1)-1,COUNTA(D:D)*COUNTA(E:E))/(COUNTA(E:E)))+1)&INDIRECT("E"&MOD(ROW(A1)-1,COUNTA(E:E))+1) 下拉填充
热心网友
时间:2022-06-17 18:51
excel排列组合提供解决方案