Hi!
I have a sheet looking something like this:
Name; Interests
Daniel; Football, Ice hockey, Golf
Eric; Ice Hockey, Golf
Aron; Football, Golf
Linda; Football, Ice hockey
What I want to do is to filter on column "Interests" and match out rows containing Golf, but not Ice Hockey or Football.
In the built in filter feature of Excel I can filter on text "containing" Golf and add a "contains not" Ice Hockey, what I would like to do is to add extra conditions to the "contains not" field.
Hope someone has come ideas about it!
Bookmarks