| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I fiter a drop down list
I want to be able to select a code from a drop down. This selection must
filter another list to reduce the chance of choosing the wrong code. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I fiter a drop down list
You can create dependent data validation lists, as described he
http://www.contextures.com/xlDataVal02.html Heinrich wrote: I want to be able to select a code from a drop down. This selection must filter another list to reduce the chance of choosing the wrong code. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I fiter a drop down list
An exemple:
A B C D 1 Fruit Vegetables Flowers 2 Apple Potato Rose 3 Orange Carrot Tulip 4 Banana Lettuce 5 Spinach Named ranges on Sheet Lists: Choice1 =OFFSET($B$1,,,,COUNTA($B$1:$Z$1)) Choice2 =$B:$B On other sheet: First choice in B2: Data/Valid/List: =Choice1 Second choice in C2: Data/Valid/List: =OFFSET(Choice2,1,MATCH(B2,Choice1,0)-1,COUNTA(OFFSET(Choice2,,MATCH (B2,Choice1,0)-1))-1) http://cjoint.com/?bvhokpCID5 http://boisgontierjacques.free.fr/pa...es_cascade.htm JB http://boisgontierjacques.free.fr On 19 jan, 03:44, Heinrich wrote: I want to be able to select a code from a drop down. This selection must filter another list to reduce the chance of choosing the wrong code. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| fiter and delete | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Hybrid Mode
