non exact match

R

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
 
J

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
 
R

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
 
R

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
Click to expand...

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
 
Top