Prev: Count the words in a cell
Next: VLOOKUP and IF formula
From: Lost Cluster on 20 May 2010 14:05
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

From: Tom-S on 21 May 2010 11:20
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
>
 | 
Pages: 1
Prev: Count the words in a cell
Next: VLOOKUP and IF formula