格式化(黃) K1:S11{=(IFERROR(INDEX($A1:$I1,ABS(SMALL(IFERROR(IF(COLUMN(A1)<MATCH("炮",$A1:$I1,),IF(A1:$I1<>"",COLUMN(A:$I)),IF($A1:A1<>"",-COLUMN($A:A))),""),1)))="炮",)+IFERROR(INDEX(A:A,ABS(SMALL(IFERROR(IF(ROW(A1)<MATCH("炮",A:A,),IF(A1:A$11<>"",ROW(1:$11)),IF(A$1:A1<>"",-ROW($1:1))),""),1)))="炮",))*(A1="")*(ROW(A1)<>6)
格式化(紅) U1:AC11{=(IFERROR(INDEX($A1:$I1,ABS(SMALL(IFERROR(IF(COLUMN(A1)<MATCH("炮",$A1:$I1,),IF(A1:$I1<>"",COLUMN(A:$I)),IF($A1:A1<>"",-COLUMN($A:A))),""),2)))="炮",)+IFERROR(INDEX(A:A,ABS(SMALL(IFERROR(IF(ROW(A1)<MATCH("炮",A:A,),IF(A1:A$11<>"",ROW(1:$11)),IF(A$1:A1<>"",-ROW($1:1))),""),2)))="炮",))*(A1="")*(ROW(A1)<>6)
二者 1與2差別
留言
張貼留言