I have a drop down with data validation and Im 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 didnt work.
Thanks

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 Im 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 didnt work.
Thanks