"Delaina" wrote in
message ...

I am using the formula:
=if(countif($h3:$h$4143,h2)=0,"single","")
because I have a list of 4000+ clients and I need to weed out all the
codes that are single.

I'd use

=IF(COUNTIF(Clients,H2)1,"","single")

and use "Clients" as a named range for $H$3:$H$4143, that way you can adjust
the range or move it to a new location without having to update all the
formulas.