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
|