| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to clear validation lists based on other validation lists
Hi,
Let's say you have 2 validation lists, the first one being the "parent" cell and then the second one being the "child" cell. The list in the childs cell is based on the selection made in the parents cell. Now my question is if i select i new value in the parent cell how can i get the child cell to clear? I tried this but it didn't work, =IF(G8="","",IF(G8="All",Div,OFFSET(Dept,MATCH(G8, DeptCol,0)-1,1,COUNTIF(DeptCol,G8),1))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lists for List Validation | Excel Discussion (Misc queries) | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Validation lists | Excel Discussion (Misc queries) | |||
| Using Lists/Validation | Excel Discussion (Misc queries) | |||
| lists and validation | Excel Worksheet Functions | |||
Threaded Mode
