T2:Z2=IF(COLUMN(A1)>$S2,"",113+COLUMN(A1))
T3:Z3=IF(COLUMN(A1)>$S3,"",113-COLUMN(A1))
T4:Z4=IF(COLUMN(A1)>$S4,"",113+COLUMN(A1)*15)
T5:Z5=IF(COLUMN(A1)>$S5,"",113-COLUMN(A1)*15)
T6:Z6=IF(COLUMN(A1)>$S6,"",113-COLUMN(A1)*15+COLUMN(A1))
T7:Z7=IF(COLUMN(A1)>$S7,"",113+COLUMN(A1)*15+COLUMN(A1))
T8:Z8=IF(COLUMN(A1)>$S8,"",113+COLUMN(A1)*15-COLUMN(A1))
T9:Z9=IF(COLUMN(A1)>$S9,"",113-COLUMN(A1)*15-COLUMN(A1))
A1:O15=IF(COUNTIF($T:$Z,ROW(A1)*15-15+COLUMN(A1)),"●","")
留言
張貼留言