Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter Data using a drop-down list
I have a sheet of data against which I have assigned categories, sometimes
more than one category to the same piece of data. Is it possible to create a drop-down list which will then filter this data not as autofilter does but as a "text contains" filter? Therefore when people want to look at certain categories, they can select from the drop-down box and it will show only the data with that particular category against it (but which may also have other categories as well). Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter Data using a drop-down list
Hi
With Autofilter, you can choose from the dropdownCustomiseContainstype in the text you are looking for. Alternatively, you can download a sample file I created called FastFilter, which allows you to type any text at the top of the column without having to use the filter dropdown. The file can be downloaded from Debra Dalgleish's site http://www.contextures.com/Fastfilter.zip or from Nick Hodge's ExcelUserGroup http://excelusergroup.org/media/p/1194.aspx -- Regards Roger Govier "Lboom2008" wrote in message ... I have a sheet of data against which I have assigned categories, sometimes more than one category to the same piece of data. Is it possible to create a drop-down list which will then filter this data not as autofilter does but as a "text contains" filter? Therefore when people want to look at certain categories, they can select from the drop-down box and it will show only the data with that particular category against it (but which may also have other categories as well). Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter Data using a drop-down list
Thanks Roger
What I am actually trying to do is use a drop-down list of pre-defined categories on a contents page to autofilter the data using a "text contains" filter. This means that the user can then pull up all the data relating to a certain category without actually having to type in the text, or even know what the category is. I am thinking I might need to use a combobox and macros, although not totally sure how to go about this! Thanks "Roger Govier" wrote: Hi With Autofilter, you can choose from the dropdownCustomiseContainstype in the text you are looking for. Alternatively, you can download a sample file I created called FastFilter, which allows you to type any text at the top of the column without having to use the filter dropdown. The file can be downloaded from Debra Dalgleish's site http://www.contextures.com/Fastfilter.zip or from Nick Hodge's ExcelUserGroup http://excelusergroup.org/media/p/1194.aspx -- Regards Roger Govier "Lboom2008" wrote in message ... I have a sheet of data against which I have assigned categories, sometimes more than one category to the same piece of data. Is it possible to create a drop-down list which will then filter this data not as autofilter does but as a "text contains" filter? Therefore when people want to look at certain categories, they can select from the drop-down box and it will show only the data with that particular category against it (but which may also have other categories as well). Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Items in Drop Down Filter List | Excel Discussion (Misc queries) | |||
Making wider drop down List for Filter | Excel Worksheet Functions | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Excel - how do I use drop down list to filter data | Excel Worksheet Functions | |||
re-ordering the list on a filter drop down | Excel Discussion (Misc queries) |