Multiple data entries in one cell for filtering purposes

  • Thread starter Thread starter hls0401
  • Start date Start date
H

hls0401

I'm trying to create a cell that has multiple data entries, however when
filtering, it comes up individually. For example:

Movie Title Movie Genre
Matrix Sci-Fi, Action
Avatar Sci-Fi, Action
Die Hard Action

Then, when filtering the table results (pulling down the menu under "Movie
Genre"), I'd like each individual genre to show up:
Sci-Fi
Action

So, if I chose "Action" the results would be:
Matrix
Avatar
Die Hard

But if I chose "Sci-Fi", the results would be:
Matrix
Avatar

Is there a way to do that without making an individual column for
everything? Thanks!
 
It wouldn't be as convenient as you describe, but would the "Custom" option
of the auto filter with the typed genre work? (For example, select custom
then select "contains" and "sci-fi")
 
Back
Top