C2右拉 下拉{=IF((ROW(A1)<COLUMN(A1))+(ROW(A1)>$A$2),"",SUM(ROW(INDIRECT("1:"&ROW(A1)))-1)+COLUMN(A1)+$A$6-1)
另解C2=IF((ROW(A1)<COLUMN(A1))+(ROW(A1)>$A$2),"",MAX($C$1:L1)+COLUMN(A1)+$A$6-1)
C14右拉 下拉{=IF((ROW(A1)>COLUMN(A1))+(ROW(A1)>$A$2)+(COLUMN(A1)>$A$2),"",MAX($C$13:L13)+SUM(N($B14:B14<>""))+1)
留言
張貼留言