J5:M7{=OFFSET($C$1,RIGHT(MAX(IF(($K$1-$B$2:$B$21-$C$2:$C$21<=0)*($K$2-$B$2:$B$21-$C$2:$C$21>=0),-1^(COLUMN(A1)>2)*(OFFSET($C$2,,MAX(ROW(A1)),20)*10^8+ROW($1:$20)))),8),MOD(COLUMN(A1),2)*ROW(A1))
N5:N7{=AVERAGE(IF(($K$1-$B$2:$B$21-$C$2:$C$21<=0)*($K$2-$B$2:$B$21-$C$2:$C$21>=0),OFFSET($C$2,,MAX(ROW(A1)),20)))
留言
張貼留言