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

Not quite Mr D! Just realised "H2" wont move when Clients is pointed
somewhere else. Doh!