Okay, Glenn answered why my quick glance showed it working... I missed the
fact that COUNTIF($A:$a,A3) will always equal at least 1 (because A3's
content will always be found in the range A:A). The fix Glenn provided
should work for you (as would my addition method).

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
That is different in construction from what I posted (I simply added up
all the COUNTIF functions to see if the total was greater than 0 (meaning
at least one match was found). However, at a quick glance, I don't really
see why the formula you used wouldn't work. Describe what you mean by "not
working" for us.

--
Rick (MVP - Excel)


"Kashyap" wrote in message
...
I tried below formula.. but not working..

=or(countif($A:$a,A3)=1,countif($e:$e,A3)=1,coun tif($i:$i,A3)=1,
countif($m:$m,A3)=1,countif($q:$q,A3)=1,countif( $u:$u,A3)=1,
countif($y:$y,A3)=1,countif($ac:$ac,A3)=1,counti f($ag:$ag,A3)=1,
countif($ak:$ak,A3)=1,countif($ao:$ao,A3)=1,coun tif($as:$as,A3)=1,
countif($aw:$aw,A3)=1,countif($ba:$ba,A3)=1)