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." wrote in message
...
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.