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

--

Best Regards,
FARAZ A. QURESHI