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

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

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

Let's assume the row is from column A to column L.

=COUNTIF(A1:L1,"PAINM")0

--
Biff
Microsoft Excel MVP


"klmiura" wrote in message
...
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

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

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

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

ROCK ON!,

Scott


"klmiura" wrote:

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

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

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?

"porter444" wrote:

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

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

ROCK ON!,

Scott


"klmiura" wrote:

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

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

Hi,

Try something like this

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

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"klmiura" wrote:

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?

"porter444" wrote:

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

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

ROCK ON!,

Scott


"klmiura" wrote:

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

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

Hi,

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

Cheers,
Shane Devenshire

"klmiura" wrote:

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?

"porter444" wrote:

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

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

ROCK ON!,

Scott


"klmiura" wrote:

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
KarenH

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

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

Yes!

Try this:

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

--
Biff
Microsoft Excel MVP


"klmiura" wrote in message
...
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?

"porter444" wrote:

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

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

ROCK ON!,

Scott


"klmiura" wrote:

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

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

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

"Shane Devenshire" wrote:

Hi,

Try something like this

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

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"klmiura" wrote:

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?

"porter444" wrote:

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

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

ROCK ON!,

Scott


"klmiura" wrote:

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