Get instant live expert help on I need help with excel yes no drop down

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am trying to make a chart that will change values dependent on a drop down list of "yes" or "no". I.E Will have a specific sum value when the drop down menu says yes, and 0 when the drop down menu says no
Solved by F. Y. in 22 mins
I have multiple cells with drop down list in excel with "yes" or "No". I would like the user to be allowed to select yes to only one of the cell and prevent him from selecting others.
Solved by O. B. in 23 mins
How do I make a drop down box in excel without the drop down options showing in the other cells below? Just want a drop down in the column under a Receipts/Invoices(C1) cell but dont want "yes", "no", or "missing" typed out in C 2-5 Also want a drop down in column under Expense Category( E1) for "Category 1", "Category 2" ,"Category 3" and "Category 4"
Solved by X. H. in 29 mins
Can you create a Yes/No drop-down box and have it link to another sheet? For example, an employee selects Yes, and it prompts by opening another sheet that has information/instructions correlating to that particular selection of Yes.
Solved by A. W. in 14 mins
I would like to add a drop down list next to "on main street" that says "yes" or "no". So if its yes I would like it to subtract 20% from the cell that says after repair value.
Solved by X. Q. in 11 mins