Data Validation

L

Lost Cluster

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
 
T

Tom-S

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?
 

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

=NameCheck - Monday??? 3
Data Validation 4
IF function 4
dates from a data validation 3
25#Data Validation 4
Dependent drop down dynamic range formula, off sheet. 7
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
data validation, dynamic ranges 3

Top