As I interpreted it..."andrew" or "am" but only One, shall be in the
range:
To check the range:
=IF(SUM(COUNTIF(A1:A10,{"andrew";"am"})+COUNTIF(A1 5:A20,{"andrew";"am"}))=1,"Correct","Wrong")
To do a Validation: (Allow:Custom)
SUM(COUNTIF($A$1:$A$10,{"andrew";"am"})+COUNTIF($A $15:$A$20,{"andrew";"am"}))=1
Hope it helped
Ola Sandström
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=380377