A COUNTIF function Challenge

I currently have the following formula that corresponds with a data
validation function:

=IF(COUNTIF($F$20:$F$21,B20)>=1,"",ROW())

Is there a way to change this formula so that it also includes cell G19? In
other words, I'd like for the string of cells to include G19, F20 & F21.

Not directly

=IF(COUNTIF($F$20:$F$21,B20)+(G19=B20)>=1,"",ROW())


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mr. G." <MrG@discussions.microsoft.com> wrote in message
news:B49BBFB8-7086-4EF8-8FF0-135A47649797@microsoft.com...
> I currently have the following formula that corresponds with a data
> validation function:
>
> =IF(COUNTIF($F$20:$F$21,B20)>=1,"",ROW())
>
> Is there a way to change this formula so that it also includes cell G19?
In
> other words, I'd like for the string of cells to include G19, F20 & F21.
>
>
>