生日幾天內到 分別不重複提取 (15117)

H2:J9{=INDEX($C:$C,SMALL(IF((TEXT($D$2:$D$21,"M/D")-TEXT($F$2,"M/D")>=0)*(TEXT($D$2:$D$21,"M/D")-TEXT($F$2,"M/D")<=CHOOSE(COLUMN(A1),0,7,30))*(COUNTIF($G$2:G$9,$C$2:$C$21)=0),ROW($2:$21),99),ROW(A1)))&""



留言