Cells with Mulitiple Values Table Filter

[vwilks14]

Hello, I am trying to create an excel table that can filter a column based on what is in each cell (using autofilter for now). I was wondering if there is a way to have multiple values in a single cell within that column?

Example:

Name	Flavor (filter)
Bob	Cherry, Chocolate
Terry	Vanilla
Jan	Mint

<tbody>
</tbody>

Where the "Cherry, Chocolate" would be the cell with two variables. I need the filter to still show "Bob" if cherry or chocolate is selected in the filter.

 

[cerfani]

Autofilter will take any unique value and add it to the list. It sounds like you should make a form that handles filtering, it can list flavors with check boxes and then go through each cell and look for the values within the cell value and hide rows it does not find the value, etc... you can create it however you like