G4:G11{=IFERROR(SMALL(IF(B$4:B$7-A$4:A$7+1>=COLUMN(A:D),A$4:A$7+COLUMN(A:D)-1),ROW(A1)),"")
H4:I11{=IFERROR(INDEX(C:C,RIGHT(SMALL(IF($B$4:$B$7-$A$4:$A$7+1>=COLUMN($A:$D),($A$4:$A$7+COLUMN($A:$D)-1)/1%+ROW($4:$7)),ROW(A1)),2)),"")
L4 下拉{=IF(ROW(A1)=1,G4,IFERROR(SUBSTITUTE(INDEX(G:G,SMALL(IF(G$4:G10=LOOKUP(1,0/(L$3:L3<>""),L$3:L3),ROW($4:10)),ROW(A2)-LOOKUP(1,0/(L$3:L3<>""),ROW($1:1)))),LOOKUP(1,0/(L$3:L3<>""),L$3:L3),),MAX(LOOKUP(1,0/(L$3:L3<>""),L$3:L3))+1))
M4:N4 下拉{=IF($L4="",INDEX(H:H,SMALL(IF(-LOOKUP(9,-$L$4:$L4)=$G$4:$G11,ROW($4:11)),ROW(A2)-LOOKUP(1,0/(L$3:L3<>""),ROW($1:1)))),"")
留言
張貼留言