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