刪除整列 無出現水果 (11919)

O2:W2{=INDEX(A:A,SMALL(IF(COUNTIF($L:$L,$C$2:$C$17),ROW($2:$17),99),ROW(A1)))&""

二日期欄用IFERROR(~,"")修改後 O2:W2下拉{=IFERROR(INDEX(A:A,SMALL(IF(COUNTIF($L:$L,$C$2:$C$17),ROW($2:$17)),ROW(A1))),"")