到期前幾天 提取 過期與超過不提 (14160)

H2:I11{=IFERROR(INDEX(E:E,SMALL(IF(($F$2:$F$16-$B$2<=$B$6)*($F$2:$F$16-$B$2>=0),ROW($2:$16)),ROW(A1))),"")

E2:F16格式化=($F2-$B$2<=$B$6)*($F2-$B$2>=0)



留言