Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter-Filter
I have created a List with data, for example:
1 Food 1.1 groceries 1.2 meals out 1.3 wine club 2 Household 2.1 maintenance yard and pool 2.2 appliances, furniture, furnishings, suplies 2.3 ... I have a column for "Areas" which in this example a 1 Food, 2 Household, and so on and the next column is for "Concepts" which would be: 1.1 groceries, 1.2 meals out and so on. I used Data Validation to select the choices for Area from a List I set in another tab. Is it possible to, for example if I choose "1 Food", that my next column where I choose the concepts only displays me the concepts that belong to 1 Food (1.2, 1.3, ...) instead of ALL the Concepts from all the Areas? ,thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter-Filter
Look at this site:
http://www.contextures.com/xlDataVal02.html where you will find excellent examples of how to create dependent lists. HTH "Ed" wrote: I have created a List with data, for example: 1 Food 1.1 groceries 1.2 meals out 1.3 wine club 2 Household 2.1 maintenance yard and pool 2.2 appliances, furniture, furnishings, suplies 2.3 ... I have a column for "Areas" which in this example a 1 Food, 2 Household, and so on and the next column is for "Concepts" which would be: 1.1 groceries, 1.2 meals out and so on. I used Data Validation to select the choices for Area from a List I set in another tab. Is it possible to, for example if I choose "1 Food", that my next column where I choose the concepts only displays me the concepts that belong to 1 Food (1.2, 1.3, ...) instead of ALL the Concepts from all the Areas? ,thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter-Filter
Thank you very much, the information was very useful.
, Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh advanced filter | Excel Discussion (Misc queries) | |||
Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |