H2:J2 下拉{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF(COUNTIFS($C$2:$C$21,$C$2:$C$21,$D$2:$D$21,">"&$D$2:$D$21)<$F$2,FIND(LEFT($C$2:$C$21),"ABC")*10^6-$D$2:$D$21/1%+ROW($2:$21)),ROW(A1)),2)),"")
M2:O13{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(COUNTIFS($C$2:$C$21,$C$2:$C$21,$D$2:$D$21,">"&$D$2:$D$21)<$F$2,$D$2:$D$21/1%+ROW($2:$21)),ROW(A1)),2)),"")
留言
張貼留言