Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |