排列組合顯示 (13647)

D1=OFFSET(A$1,(ROW(A1)-1)/COUNTA($B:$B),)&""

E1=IF(D1="","",OFFSET(B$1,MOD(ROW(A1)-1,COUNTA($B:$B)),))

D E格式化=MOD(COUNTIF($E$1:$E1,$E1),2)*($E1<>"")