List

G

Guest

Respected members,

I.E. I wish to create a a validation list in A1, A2 & A3, the source data is
held in
cells A10:A12 as follows
"Hello"
"Goodbye"
"No thanks"

If "hello" is selected from the drop down list in A1, then the drop down for
A2 & A3 should only show options "Goodbye" and "No thanks", in other words
the lists should only show values that have'nt been used elsewhere in A1:A3.

Any idea's?
 
G

Guest

You could try this:

In cells A10:A12 use the following formulas:

=IF(OR(A1="Hello",A2="Hello",A3="Hello"),"","Hello")
=IF(OR(A1="Goodbye",A2="Goodbye",A3="Goodbye"),"","Goodbye")
=IF(OR(A1="No Thanks",A2="No Thanks",A3="No Thanks"),"","No Thanks")

HTH,
Elkar
 
G

Guest

Thanks for the tip Elkar

Elkar said:
You could try this:

In cells A10:A12 use the following formulas:

=IF(OR(A1="Hello",A2="Hello",A3="Hello"),"","Hello")
=IF(OR(A1="Goodbye",A2="Goodbye",A3="Goodbye"),"","Goodbye")
=IF(OR(A1="No Thanks",A2="No Thanks",A3="No Thanks"),"","No Thanks")

HTH,
Elkar
Click to expand...
 

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

Similar Threads

how to use if formula in list (data validation list) 1
Return Unique Entries Only 5
Data Validation and drop-down list using IF, AND and what else? 8
Date lists 3
Remove blank cells from data validation drop down box 3
Creating a formula relating to several cells 2
How to have conditional dropdown 1
Copying and pasting from a range 3

Top