cells that "contain" values
 

hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks

cells that "contain" values
 

What do you want to happen once you find them?

Select those cells?
Count them?
List their addresses?
Sum other cells, contingent upon the matched cells?


***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks

cells that "contain" values
 

well i hadn't thought of that but i usually use if statements to find certain
cell(s) and then copy it to another cell(s). other times i use them as the
basis for further equations, ie if the outcome is true then use a certain
equation and if the outcome is false, ignore that cell

"Ron Coderre" wrote:

What do you want to happen once you find them?

Select those cells?
Count them?
List their addresses?
Sum other cells, contingent upon the matched cells?


***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks

cells that "contain" values
 

Try something like this:

With
A1: (a value that may contain the word "cow")

Then
B1: =IF(COUNTIF(A1,"*COW*"),formula if TRUE, formula if FALSE)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

well i hadn't thought of that but i usually use if statements to find certain
cell(s) and then copy it to another cell(s). other times i use them as the
basis for further equations, ie if the outcome is true then use a certain
equation and if the outcome is false, ignore that cell

"Ron Coderre" wrote:

What do you want to happen once you find them?

Select those cells?
Count them?
List their addresses?
Sum other cells, contingent upon the matched cells?


***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks

cells that "contain" values
 

yeah that is perfect, thanks

"Ron Coderre" wrote:

Try something like this:

With
A1: (a value that may contain the word "cow")

Then
B1: =IF(COUNTIF(A1,"*COW*"),formula if TRUE, formula if FALSE)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

well i hadn't thought of that but i usually use if statements to find certain
cell(s) and then copy it to another cell(s). other times i use them as the
basis for further equations, ie if the outcome is true then use a certain
equation and if the outcome is false, ignore that cell

"Ron Coderre" wrote:

What do you want to happen once you find them?

Select those cells?
Count them?
List their addresses?
Sum other cells, contingent upon the matched cells?


***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks

cells that "contain" values
 

=ISNUMBER(FIND("cow",A1))
rok wrote:
yeah that is perfect, thanks

"Ron Coderre" wrote:

Try something like this:

With
A1: (a value that may contain the word "cow")

Then
B1: =IF(COUNTIF(A1,"*COW*"),formula if TRUE, formula if FALSE)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

well i hadn't thought of that but i usually use if statements to find certain
cell(s) and then copy it to another cell(s). other times i use them as the
basis for further equations, ie if the outcome is true then use a certain
equation and if the outcome is false, ignore that cell

"Ron Coderre" wrote:

What do you want to happen once you find them?

Select those cells?
Count them?
List their addresses?
Sum other cells, contingent upon the matched cells?


***********
Regards,
Ron

XL2002, WinXP


"rok" wrote:

hi guys
does anyone know of a formula or any other way to find if a cell contains a
certain value. I am looking for something like an IF statement that will
evaluate the following:
cell value: "the cow jumped over the moon"

equation: find all cells that contain the word "cow"

I know this is a simple example but hopefully it explains what i am looking
for

thanks