菱形 字母A開始顯示 (13111)

C2:U20=IF((ABS(COLUMN(A1)-10)<=ABS(MOD(ROW(A1)-1,$A$2)-($A$2-2)*(ROW(A1)>$A$2)))*(ROW(A1)<=$A$2*2-1),CHAR(ABS(COLUMN(A1)-10)+MOD(ABS($A$2-ROW(A1)),$A$2)+65),"")



留言