A COUNTIF function Challenge

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Not directly

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


--

HTH

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