Identify if Text is in that row and return True or False

K

klmiura

I have a worksheet that has several columns and I want a formula to identify
that row as true or false if it contains the following text: PAINM

I want to put this formula at the end of the row and just have it state
True if it is in that row or False if it is not.

Thanks
Karen
 
P

porter444

=IF(COUNTIF(A1:L1,"PAINM")>0,"TRUE","FALSE")

--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott
 
K

klmiura

I tried this and the first one that was suggested and it doesn't work. I
have a cell that has several other words in it including the PAINM would this
be the issue because it doesn't have just PAINM?
 
S

Shane Devenshire

Hi,

Try something like this

=SUMPRODUCT(--ISNUMBER(SEARCH("PAINM",A1:G1)))

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
S

Shane Devenshire

Hi,

I should add that my last solution is not case sensitive, for that use FIND
instead of SEARCH.

Cheers,
Shane Devenshire
 
T

T. Valko

would this be the issue because it doesn't have just PAINM?

Yes!

Try this:

=COUNTIF(A1:L1,"*PAINM*")>0
 
K

klmiura

XOXOXO..you are the best this worked great. Thanks so much and have a great
thanksgiving.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if/true/false help 3
IF cell contains certain text return value 9
if statement true=now false retains last true 3
Excel How to get output of the formula instead of True or false 1
Copying "Exact" Function 2
looking for a function that hopefully exist 1
Search an alphanumeric in a column and return true/false 9
Find certain text in a cell 3

Top