Three lists, only one can be "yes"

**flabb** · 05-22-2014, 06:51 AM

Hi, I've tried to google this, but haven't got an answer, so I try here :-).

I have three lists. All of them with the option "Yes" or "No". This is what I want:

If one of them is "yes", then the two others should be turned to "no".
The list option (yes/no) should be available at all times.
I dont use VB.

Example:

List one is "yes"
List two is "no"
List three is "no"

If I then want list three to be "yes", I should go to list three and choose "yes". The instance I choose "yes", the other two should go to "no".
If I then want list two to be "yes", I shold go in list two and choose "yes", and the other lists should automaticly go to "no".
Is this possible?

Thanks for any advice!!

**zbor** · 05-22-2014, 06:53 AM

Yes, but only with VB.

**flabb** · 05-22-2014, 07:03 AM

aahhh, sh**!

**Sam Capricci** · 05-22-2014, 07:09 AM

maybe not, are you averse to using a small reference table where you control what is yes or no? see attached...

EDIT: you would have to control the yes or no with those three inputs.

**flabb** · 05-22-2014, 07:31 AM

Hi.

I don't know if you got me right, but;
I've edited your file, by makeing the Yes/No (in the "I" column) to lists. What I want is that there should never be more than one "yes" in the lists (area: I3:I5). And if you try to make two "yes"s, then the previous "yes" should automaticly turn to "no".

**Sam Capricci** · 05-22-2014, 07:36 AM

Yes, i know, that is the flaw i noted in mine, you'd have to control the yes/no in those cells but the rest of the lists would automatically pick up the yes and no from those three. I've been trying to do an if then statement that would say that if you pick yes for list 1, list 2 and list 3 will be no, then if you pick yes for list 2, list 1 and 3 would be no... etc. But haven't been able to work that out yet.
Zbor has better skills than I and is probably right about the visual basic.

If i can work it out i'll post it.

**zbor** · 05-22-2014, 07:43 AM

Only VBA can trace your changes.

Maybe to write position of yes. In that case other will be automatically no.

Change B17 number

**Sam Capricci** · 05-22-2014, 07:53 AM

told you Zbor had better skills than I, so i "cheated" and adapted what he gave you a little with adding a dropdown selection and the changes flow through.

EDIT: so if that suits your needs give the credit to Zbor for pulling the rabbit out of the hat.

**flabb** · 05-22-2014, 08:11 AM

Thanks guys!
It's not exactly what I was looking for, but a good workaround :-)
Thanks again, for quick and good answers!!!

Three lists, only one can be "yes"

LinkBack

Thread Tools

Rate This Thread

Display

Three lists, only one can be "yes"

Re: Three lists, only one can be "yes"

Re: Three lists, only one can be "yes"

Re: Three lists, only one can be "yes"

Re: Three lists, only one can be "yes"

Re: Three lists, only one can be "yes"

Re: Three lists, only one can be "yes"

Re: Three lists, only one can be "yes"

Re: Three lists, only one can be "yes"

Thread Information

Users Browsing this Thread

Similar Threads

Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"

[SOLVED] How to USE """"" cells count """"" change font color

Sorting "apples" and "bananas" from one list into two separate lists?

Formula returning result of "True" or "False" instead of "1" or "0"

Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next

Bookmarks

Bookmarks

Posting Permissions