B3:N9{=IF(OR(COLUMN(A1)=ROW(INDIRECT(8-ROW(A1)+(ROW(A1)=7)*2&":"&6+ROW(A1)-(ROW(A1)=7)*2))*MOD(ROW(INDIRECT(1+(ROW(A1)=7)*2&":"&ROW(A1)*2-1-(ROW(A1)=7)*2)),2)),CHAR(COUNTIF($B$2:$N2,"><")+COUNTIF($A3:A3,"><")+65),"")
B3:N9 格式化=B3<>""
另解=IF(OR(1-ISERR(FIND(","&COLUMN(A1)&",",","&CHOOSE(ROW(A1),7,"6,8","5,7,9","4,6,8,10","3,5,7,9,11","2,4,6,8,10,12","3,5,7,9,11")&","))),CHAR(COUNTIF($B$2:$N2,"><")+COUNTIF($A3:A3,"><")+65),"")
留言
張貼留言