Search for a row containing

[peru]

Hi. This is my first post here. Hope i`m in the correct section.

I have a list of words and i want to filter it to show just the rows that are containing the words i want. so here`s an example of my list:

column "A"

stress
this is a stressful situation
are you stressless
destress
antistress remedy
good antistress remedy


Now, i want in column "B" to show the columns that contains the word that start with STRESS, and to filter out words like "antistress", "destress", but leave the columns that have "stressless", "stressful".

In other words, if a word in the column start with "stress" is GOOD, but if a word in the column have some characters before the "STRESS" word then is BAD.

I tried using IF ISNUMBER, but i don`t know how to deal with it.

Please Login or Register  to view this content.

So in the B1 i enter STRESS.... but how do tell it that when is stressful is OK, but when is antistress is not ok?


thanks

[TMS]

Why not just use Autofilter with "begins with".


Regards, TMS

[peru]

hi,

i want to set a special filter criteria, i want that in the column B to enter the words i want to INCLUDE and in the column C the words to exclude. I want to be able to filter my list better than with autofilter.

[peru]

i`m thinking of something like

http://www.excelforum.com/excel-work...-statment.html

but i don`t know how to apply it

[TMS]

The example you quote uses the formula:

=IF(SUM(COUNTIF(A1,{"*MDF*","*PB*","*PART*"}))>0,"Machine1","Machine2")

That would be equivalent to "contains" but looking for MDF, PB or PART.

My understanding is/was that you wanted to find words at the begininning of the string. In which case, I don't see how this would work for you.

Regards, TMS

[peru]

please guys help me out...

i have this formula

Please Login or Register  to view this content.

Could you please tell me how do i replace the CRITERIA

Please Login or Register  to view this content.

with values from G1, G2 and G3?


thanks

[peru]

I want to modify it so it will search for values from some CELLs i want. Instead of MDF, PB or PART, i want to tell it to look in G1, G2, G3.

Now... in those G1 i want to tell it to look for value like stress* -> meaning stress PLUS other characters after it....

Do you have any idea?

The example you quote uses the formula:

=IF(SUM(COUNTIF(A1,{"*MDF*","*PB*","*PART*"}))>0,"Machine1","Machine2")

That would be equivalent to "contains" but looking for MDF, PB or PART.

My understanding is/was that you wanted to find words at the begininning of the string. In which case, I don't see how this would work for you.

Regards, TMS

[TMS]

You know what you want. Try it. I don't think it will work because you want the cells to start with the word you are looking for.

Regards, TMS

[Fotis1991]

Hi

I give you, one other solution, using, SEARCH & IF functions, with a helper column.

Hopes to be OK for you

Regards.