non exact match

[robert_woodie]

=AND($A$1 = $A1,ROW()>1,$A$1<>"")
I am using the above formula for conditional formating. I need i
modified to work if whatever is in A1 appears anywhere within th
coloumn. Currentlly it only does exact match but i have multiple word
in each cell

Hope this is possible
Rober

 

[Jason Morin]

I'm not sure how you're using the your current formula,
but you can use this:

=COUNTIF(A:A,"*"&A1&"*")

HTH
Jason
Atlanta, GA

 

[robert_woodie]

reading your reply I used this:
=AND("*"&$A$1&"*" = $A1,ROW()>1,$A$1<>"")
unfortunatlly it didnt work.
I am using the formula as a conditional format formula
can ne one help?

Rober

 

[Ron Rosenfeld]

reading your reply I used this:
=AND("*"&$A$1&"*" = $A1,ROW()>1,$A$1<>"")
unfortunatlly it didnt work.
I am using the formula as a conditional format formula
can ne one help?

Robert

I would suggest using Jason's formula, instead of yours.

Of course, although you wrote "modified to work if whatever is in A1 appears
anywhere within the coloumn" I assume you do not want to include A1 in your
definition of 'anywhere within the column', so I would modify Jason's formula
as follows to read: =COUNTIF(A:A,"*"&A1&"*")>1


--ron