Kashyap wrote:
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)


Well, your first test is always going to be true...A3 is always in column A.
And you can drop all of the "=1".

=OR(COUNTIF($E:$E,A3),COUNTIF($I:$I,A3),COUNTIF($M :$M,A3),
COUNTIF($Q:$Q,A3),COUNTIF($U:$U,A3),COUNTIF($Y:$Y, A3),COUNTIF($AC:$AC,A3),
COUNTIF($AG:$AG,A3),COUNTIF($AK:$AK,A3),COUNTIF($A O:$AO,A3),
COUNTIF($AS:$AS,A3),COUNTIF($AW:$AW,A3),COUNTIF($B A:$BA,A3))