Try this formula

=AND(COUNTIF(InputPC,F10)1,F10<"Select")

--
HTH

Bob Phillips

"cafe" wrote in message
...

Thanks Bob,

The INPUTPC is the range F10:AT10.

Yes, that works fine except that I have "Select" through out the
range. Is there any way I can have countif check for duplicates but
ignore if the cell has the word Select?

See attached image

Please help, i need to resolve this today!!.

Reagards,

Cafe


+-------------------------------------------------------------------+
|Filename: DupCoutIf.gif |
|Download: http://www.excelforum.com/attachment.php?postid=3682 |
+-------------------------------------------------------------------+

--
cafe
------------------------------------------------------------------------
cafe's Profile:
http://www.excelforum.com/member.php...o&userid=16145
View this thread: http://www.excelforum.com/showthread...hreadid=394458