excel如何计数排列组合答:D1= =IF(ROW()>COUNT(A:A)*COUNT(B:B)*COUNT(C:C),"",INDEX(A:A,QUOTIENT(ROW()-1,COUNT(B:B)*COUNT(C:C))+1)&INDEX(B:B,MOD(QUOTIENT(ROW()-1,COUNT(C:C))+1-1,COUNT(B:B))+1)&INDEX(C:C,MOD(ROW()-1,COUNT(C:C))+1))E1= =D1 E2= =INDEX(D:D,MIN(...
excel如何排列组合答:何必用宏呢?用随机函数,你按一下F9就会自动生成新一列数 D,E ,F中分别输入 =OFFSET(A1,INT(RAND()*6)-1,0)=OFFSET(B1,INT(RAND()*8)-1,0)=OFFSET(C1,INT(RAND()*6)-1,0)刚测试了下,不知道怎么用RAND的时候总是偶尔会出点问题,修改了下 =OFFSET(A1,INT(RANDBETWEEN(1,5))-1,...