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.
=IF(ISNUMBER(SEARCH(B$1,$A2)),TRUE, FALSE)
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
Bookmarks