F
FARAZ QURESHI
I have a column reflecting branches & cases as follows:
CASE1 BRANCH1
CASE2 BRANCH1
CASE3 BRANCH2
CASE4 BRANCH2
CASE5 BRANCH3
What is required is a Data Validation List Type of check on C1 which shall
display only a unique list of three branches instead of 5 entries.
Furthermore, when a branch like Branch2 is selected only the respective
cases's list i.e. Cases3 & Case4 is available in D1.
Thanx
CASE1 BRANCH1
CASE2 BRANCH1
CASE3 BRANCH2
CASE4 BRANCH2
CASE5 BRANCH3
What is required is a Data Validation List Type of check on C1 which shall
display only a unique list of three branches instead of 5 entries.
Furthermore, when a branch like Branch2 is selected only the respective
cases's list i.e. Cases3 & Case4 is available in D1.
Thanx