| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by predefined list
I need help to create an filter and hope some of you skilled people can help
me. I have a list that is used to insert selections in cells. I can add several selection to each cell, and each selection are separated by comma. I need an filter (autofilter look-Alike) that utilize the same list in a dropdown list as filter input. MyList txt1 txt2 txt3 Cell C3: txt2,txt3 Cell C4: txt3 Cell C5: txt1,txt2,txt3 Filter "txt2" should give row 3 and 5 as result |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Predefined text list | Excel Discussion (Misc queries) | |||
| Formula (not adv. filter) to list unique values from list | Excel Worksheet Functions | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
| Anywhere to see list of predefined functions available? | Excel Programming | |||
Threaded Mode
