(找最近日期 無論 > 或 <) {=INDEX(B:B,RIGHT(MIN(IF((A$2:A$21=C2)*(B$2:B$21<>D2),ABS(B$2:B$21-D2)/1%+ROW($2:$21))),2))
找 <目标日期中最大日期 ;若無 ,找 >目标日期中最小日期=INDEX(B:B,IFERROR(LOOKUP(1,0/(A$2:A$21=C2)/(B$2:B$21<D2),ROW($2:$21)),MATCH(,0/(A$2:A$21=C2)/(B$2:B$21>D2),)+1))
留言
張貼留言