(順時針)D2右拉 下拉{=IF((ROW(A1)>$B$2)+(COLUMN(A1)>$B$2),"",IFERROR(CHOOSE(MATCH(COLUMN(A1),MAX(ROW(A1),$B$2-ROW(A1)+1)-INT(($B$2+1)/2)+1+IF({1,0},MIN(ROW(A1),$B$2-ROW(A1)+1)*2-2,),),ROW(A1),$B$2*2-ROW(A1)),""))
(選擇 1順或 2逆){=IF((ROW(A1)>$B$2)+(COLUMN(A1)>$B$2),"",IFERROR(CHOOSE(MATCH(COLUMN(A1),MAX(ROW(A1),$B$2-ROW(A1)+1)-INT(($B$2+1)/2)+1+IF(ABS({2,1}-$B$6),MIN(ROW(A1),$B$2-ROW(A1)+1)*2-2,),),ROW(A1),$B$2*2-ROW(A1)),""))
留言
張貼留言