DATA VALIDATION LISTING UNIQUES


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
 
Ad

Advertisements

Ad

Advertisements

F

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


Bob Phillips said:
See http://www.contextures.com/xlDataVal02.html

--
---
HTH

Bob


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top