If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data Validation
I have a drop down with data validation and I’m trying to compare names from
two name ranges. The first name range is called NameCheck, it has the names of all my employees. The second name range is called Monday and that has the names of the people who are off on Monday. I need the names of the people who work on Monday to not show up when I go to my drop down. At the moment my source is =NameCheck and my drop down shows every ones name but I changed it to =if((NameCheck=Monday)=True," ",NameCheck) and that didn’t work. Thanks |
#2
|
|||
|
|||
Data Validation
Not sure I'm understanding properly what you're after, but it sounds like if
you "need the names of the people who work on Monday to not show up" on your dropdown, then that's the same as a list of people who are off on Monday - and you already have that list as name range Monday, so source=Monday. Does that work for you? "Lost Cluster" wrote: I have a drop down with data validation and I’m trying to compare names from two name ranges. The first name range is called NameCheck, it has the names of all my employees. The second name range is called Monday and that has the names of the people who are off on Monday. I need the names of the people who work on Monday to not show up when I go to my drop down. At the moment my source is =NameCheck and my drop down shows every ones name but I changed it to =if((NameCheck=Monday)=True," ",NameCheck) and that didn’t work. Thanks |
Thread Tools | |
Display Modes | |
|
|