Thread: How to clear validation lists based on other validation lists
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ben Ben is offline
external usenet poster
  
Posts: 509
Default 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)))
Reply With QuoteReply With Quote