How to Perform Multiple Searches Using One SEARCH Function in Excel

by Charley Kyd on June 12, 2012

In my previous post, How to Add Advanced Filter Capabilities to Excel Tables, I explained how to use a long formula within a Table to simplify complex filtering.

The formula relies on Excel’s SEARCH worksheet function, which gives us the power to search for one string within another string. The search is not case sensitive and it can use wildcards.

Unfortunately, however, SEARCH was designed to search for only one string at a time. This limitation has been a problem for me because I often need to include more than two criteria when I’m filtering data in one column.

To see what I mean, take a look at the content of four cells from the Tags column in my Excel Table: [click to continue...]

 

Previous post:

Next post: