Hello.

I would like to list multiple values from a dropdown box in the same cell AND filter for each individual value, not the whole list.

For example, if "ball, bat, glove" are listed together in the same cell by selecting each value from a dropdown (using data validation and a macro to allow for multiple selections), the column header's dropdown will show "ball, bat, glove" as a selection (along with all of the other selections listed individually as "ball" "bat" and "glove" that were values from other rows in the worksheet). Is there a way to get the "ball, bat, glove" row to be counted once as "ball", once as "bat", and once as "glove" when filtering--instead of "ball, bat, glove"?

Thank you in advance for your help!