Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
Search column for value and return TRUE or FALSE | Excel Worksheet Functions | |||
Look up to return a true/false value | Excel Worksheet Functions | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
How do I return True False | Excel Worksheet Functions |