Excel - Advanced Text Filters

I have a long list of strings:

"apple is red"
"apple is big"
"apple tastes yummy"
"lemon is yellow"
"lemon is big"
"lemon tastes sour"
"orange is rotten"
"watermelon is red"

Now I want to create a short list of filter words (way more than just 2) like:

"red"
"big"

I need an Excel fitler that can return the rows or records that DOES NOT have the words from the filter. Result should be:

"apple tastes yummy"
"lemon is yellow"
"lemon tastes sour"
"orange is rotten"

I would greatly appreciate your ideas! I hope I can do it without using VBA.

Answers


(this question is best asked at superuser)

You could use a simple working column formula and then filter the TRUE results

If

  1. your strings were in column A
  2. your list is in B1:B10

then in C1 array enter (by pressing Shift & Ctrl & Enter) this formuls =OR(ISNUMBER(SEARCH($B$1:$B$10,A1)))

Then filter column C for the FALSE results


Need Your Help

How to serialize list to XML without parent element

c# .net xml

I'm using System.Xml.Serialization.XmlSerializer to serialize my class into a XML document.

Formatting a title for FancyBox

javascript jquery fancybox

I don't know javascript at all, but I am trying to format my titles/captions for my pictures that are being displayed using FancyBox. In my title attribute in my <a> tag, I have an individuals

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.