Advanced Filter

J

Jason

Greetings,

I have a columns of data that look similar to below that I
would like to sort on.

Column A
Burger King
McDonald's
Taco Bell, KFC, Wendy's
KFC
Wendy's
Burger King, Wendy's

The problem I am having is that when I want to filter all
burger kings, I will only get those Burger Kings that are
individually in a cell and will not get those that are
part of a string. Is it possible to somehow use advanced
filter so that it will evaluate the contents of a cell and
pull based upon the criteria even if it is included in a
string of text. For example, If I were to
choose "Wendy's" from the filter, I would like to receive
the following results:

Column A
Taco Bell, KFC, Wendy's
Wendy's
Burger King, Wendy's

Thanks for your help!

Jason
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top