excel排列组合ABCDEF?答:=CONCAT(IFERROR(MID("ABCDEF",MID(BASE(ROW(),2,6),COLUMN(A:F),1)*{1,2,3,4,5,6},1),""))这个要2019以上版本。A AB ABC ABCD ABCDE ABCDEF ABCDF ABCE ABCEF ABCF ABD ABDE ABDEF ABDF ABE ABEF ABF AC ACD ACDE ACDEF ACDF ACE ACEF ACF AD ADE ADEF ADF AE AEF A...
如果有4个数,1,2,3,4,我要把他们在Excel表中做成24组不同的排列组合,怎...答:Sub PaiLie() dim a,b,c,d,n as long for a = 1 to 4 for b = 1 to 4 if b = a then goto bNext for c = 1 to 4 if c = a or c = b then goto cNext for d = 1 to 4 if d = a or d = b or d = c then goto dNext ...