循環三角形顯示 A~Z (13924)

B2右拉 下 拉=IF((ROW(A1)>$A$1)+(COLUMN(A1)>ROW(A1)),"",CHAR(MOD(COLUMN(A1)+SUMPRODUCT(ROW($1:1))-ROW(A1)-1,26)+65))

另解=IF((ROW(A1)>$A$1)+(COLUMN(A1)>ROW(A1)),"",CHAR(MOD(COUNTIF($1:1,"><")+COUNTIF($A2:A2,"><"),26)+65))



留言