Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filter and relations between fields
in cell A2, user can select only A and B, i know how to do this.
if A is selected in cell A2, i need only aa, ab, ac can be seclect in cell A3, if B is selected in cell A2, i need only ba, bb, bc can be seclect in cell A3. can someone tell me how can do this? -- Dennis Cheung |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filter and relations between fields
Debra Dalgleish shows how you can set up dependent data validation
he http://www.contextures.com/xlDataVal02.html Hope this helps. Pete On Sep 15, 2:15*pm, Dennis Cheung wrote: in cell A2, user can select only A and B, i know how to do this. if A is selected in cell A2, i need only aa, ab, ac can be seclect in cell A3, if B is selected in cell A2, i need only ba, bb, bc can be seclect in cell A3. can someone tell me how can do this? -- Dennis Cheung |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter unique on key fields only | Excel Worksheet Functions | |||
Lookups and References in relations to countA or sumproducts | Excel Worksheet Functions | |||
Return unique fields only - but not a filter? | Excel Worksheet Functions | |||
How do I set up filter for page fields in pivot table? | Excel Discussion (Misc queries) | |||
filter on color-filled fields | Excel Worksheet Functions |