Try
=if(countif($h$3:$h$4143,h2)=0,"single","")
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"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 am getting a "single" on the last client of
the group. For example:
CLIENT |STATUS
ABC |
ABC |
ABC | Single
123 | Single
456 | Single
I am trying to eliminate that last "single" to where it truely is one
singular clients with the word "single." I tried it the opposite way
where I would output "duplicate" but that didn"t seem to work any
better... suggestions are appreciated if you think there is a better
way to find all single clients.
--
Delaina
------------------------------------------------------------------------
Delaina's Profile:
http://www.excelforum.com/member.php...o&userid=24151
View this thread: http://www.excelforum.com/showthread...hreadid=493067