門市有指定商品 顯示所有商品 (12579)

E4:F16=IFERROR(INDEX(A:A,RIGHT(SMALL(IF(1-ISNA(MATCH($A$2:$A$16&$F$1,$A$2:$A$16&$B$2:$B$16,)),MATCH($A$2:$A$16,$A:$A,)/1%+ROW($2:$16)),ROW(A1)),2)),"")