X2:X3=CHAR(RANDBETWEEN(65,84))
B2:U21格式化=IF($X$3<$X$2,-1^($X$3<$X$2)*(ROW(A1)-1)+CODE($X$2)-64+IF(ROW(A1)>CODE($X$2)-64,(ROW(A1)-(CODE($X$2)-64))*2,),-1^($X$3<$X$2)*(ROW(A1)-1)+CODE($X$2)-64-IF(ROW(A1)>20-(CODE($X$2)-64)+1,(ROW(A1)+CODE($X$2)-64-21)*2,))=COLUMN(A1)
另解=20-ABS(20-(MOD(CODE($X$2)-64+-1^($X$3<$X$2)*(ROW()-2)-1,38)+1))
=20-ABS(20-(MOD(CODE($X$2)-64+IF($X$3>$X$2,1,-1)*(ROW()-2)-1,38)+1))=COLUMN(A1)
回覆刪除太強
回覆刪除