A COUNTIF function Challenge

[Guest]

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.

 

[Bob Phillips]

Not directly

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


--

HTH

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