Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple data entries in one cell for filtering purposes
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple data entries in one cell for filtering purposes
no, i guess this is the only way.
"hls0401" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple data entries in one cell for filtering purposes
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") "hls0401" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering multiple criteria to get specific data | Excel Discussion (Misc queries) | |||
Filtering Lists With Targeted Data in Multiple Columns | Excel Discussion (Misc queries) | |||
count the number of cell entries after filtering | Excel Discussion (Misc queries) | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions | |||
How do I avoid saving multiple data files for versioning purposes. | Excel Discussion (Misc queries) |