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
DNS Proxy 15
Filtering Text Data from Multiple columns 6
OT: In Defense of Doom 3 18
Multiple Employee Name Entries in One Cell 1
How do I Select Multiple entries from Valid list for a Cell 1
Changing data in column for multiple rows 1

Top