K2:K13{=REPT(J2,RIGHT(MIN(IF(YEAR(I2)=YEAR(I$2:I$13),I$2:I$13*10^8+J$2:J$13)),8)-J2=0)
E2:F7{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(YEAR(N(+$B$1:$B$12))<>YEAR($B$2:$B$13),$C$2:$C$13*10^8+ROW($2:$13)),ROW(A1)),8)),"")
M2:N6{=IFERROR(INDEX(I:I,RIGHT(LARGE(IF($K$2:$K$13<>"",$J$2:$J$13/1%+ROW($2:$13)),ROW(A1)),2)),"")
留言
張貼留言