Multiple data entries in one cell for filtering purposes

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!
 
E

E.Q.

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data from two sub records into one form? 3
One To Many To One Common Problem 2
Search and consolidate multiple values in multiple fields 2
Filtering Text Data from Multiple columns 6
Changing data in column for multiple rows 1
Data Validation and Cell Protection 0
Multiple dates in one cell? 6
MULTIPLE ENTRIES IN ONE CELL 0

Top