Filter list to show only selected items

Originally Posted by andrew_senior4

How would I go about filtering the attached example to only show customers who have bought a hammer and any other product?

Select the filter drop down on C1 and check or uncheck what you want displayed.

Maybe you should present us with an example workbook of your before and after. Pictures are good to look at, but not good to work on.

Hi Andrew,

No, this doesn't appear any clearer. I see on the after it appear you have filtered by Hammer, Spanner, Nails, and Screws. If this is the case, why is Brain and Edward not part of the list.

Maybe some more explanation as to the logic.