DATA VALIDATION LISTING UNIQUES

[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

 

[Bob Phillips]

See http://www.contextures.com/xlDataVal02.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[FARAZ QURESHI]

Thanx Bob,

That sure was a great help! However any idea as to how to calculate the same
in case of Dates?

Suppose I have same sort of list as follows:

CASE1 01-JAN-08
CASE2 15-JAN-08
CASE3 01-FEB-08
CASE4 31-MAR-08
CASE5 15-MAR-08

I have a list of months i.e. January to December presented in list option at
C1 upon selecting March, I want the list in D1 to be reflecting the options
of only 31-MAR-08 and 15-MAR-08 i.e. dates falling in March

--

Best Regards,
FARAZ A. QURESHI

See http://www.contextures.com/xlDataVal02.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)