Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation when a list is already in place
I want to be able to allow an option on a drop down list only if another cell
has a particular value. What I am trying to do is I have a list of people with their title (Mr,Ms,Mrs,Miss) and I also have Gender (Male,Female). Both of these a dropdown lists. I would like when Ms,Mrs or Miss is selected, it only allows an entry of Female to gender, and if Mr is selected it only allows Male for Gender. Is there any way to do this? Cheers |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation when a list is already in place
See:
http://www.contextures.com/xlDataVal02.html -- Gary's Student gsnu200702 "Alex" wrote: I want to be able to allow an option on a drop down list only if another cell has a particular value. What I am trying to do is I have a list of people with their title (Mr,Ms,Mrs,Miss) and I also have Gender (Male,Female). Both of these a dropdown lists. I would like when Ms,Mrs or Miss is selected, it only allows an entry of Female to gender, and if Mr is selected it only allows Male for Gender. Is there any way to do this? Cheers |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation when a list is already in place
Us a custom type in the DV with a formula of
=IF(OR(H1="Ms",H1="Miss",H1="Mrs"),"Female","Male" ) -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alex" wrote in message ... I want to be able to allow an option on a drop down list only if another cell has a particular value. What I am trying to do is I have a list of people with their title (Mr,Ms,Mrs,Miss) and I also have Gender (Male,Female). Both of these a dropdown lists. I would like when Ms,Mrs or Miss is selected, it only allows an entry of Female to gender, and if Mr is selected it only allows Male for Gender. Is there any way to do this? Cheers |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation when a list is already in place
Hi Bob
I don't think that will work I think the Op will need to set up 2 cells, one with M and one with F (I used K1 and K2) and use DV with List and enter the following into the List source =IF(A1="Mr",$K$1,$K$2) -- Regards Roger Govier "Bob Phillips" wrote in message ... Us a custom type in the DV with a formula of =IF(OR(H1="Ms",H1="Miss",H1="Mrs"),"Female","Male" ) -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alex" wrote in message ... I want to be able to allow an option on a drop down list only if another cell has a particular value. What I am trying to do is I have a list of people with their title (Mr,Ms,Mrs,Miss) and I also have Gender (Male,Female). Both of these a dropdown lists. I would like when Ms,Mrs or Miss is selected, it only allows an entry of Female to gender, and if Mr is selected it only allows Male for Gender. Is there any way to do this? Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |