Here is one solution:
=AND(COUNTIF($C$1:$C$7,B1)<0,COUNTIF($B$1:B1,B1)< =1)
See encl. zip-file:
http://www.excelforum.com/attachment...hmentid=&stc=1
HTH
Ola Sandström
+-------------------------------------------------------------------+
|Filename: Book5.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3568 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=384271