Find multiple values in Excel

March 7, 2012 at 12:53:05
Specs: Windows XP
Hello,

I have an Excel spreadsheet with a column of hyperlinks to all of the photos on my hard drive. In this spreadsheet I have a column for key tags for each photo. I want to be able to search the key tags and isolate each row that contains the key tags, hyperlinks and additional data in the spreadsheet. Here is an example of the key tags column

Events Baby Shower Lunch Feb 09 Kim's Baby Shower

Right now if I do the basic CRTL F search and I type in "Events Lunch" it will not find the above entry. Is there a Macro I can set up to continuously use that would put each matching entry in a new spreadsheet? Also I would like to be able to search for words that are not on the spreadsheet and produce a search with results, for example if I searched "Books Baby Shower" and no key tags in the entire spreadsheet had "Books" I would like to still see everything with "Baby" and "Shower" in the key tags column.

any tips or better ideas would be greatly appreciated,

Thanks.


See More: Find multiple values in Excel

Report •

#1
March 7, 2012 at 13:23:13
Instead of searching for Events Lunch, you can find the above entry with:

Events * Lunch

as long as the "Match entire cell contents" box is not checked.

Instead of searching for Books Baby Shower you can find the above entry with:

b? * shower

as long as the "Match entire cell contents" box is not checked.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 8, 2012 at 05:23:12
Thanks for the reply, the *Search works great for un-ordered words but is there a way to search for multiple entries at once? For example if under my key tags I have the following:

Events Phil's Retirement Party
Image used on website web homepage
Events Baby Shower Lunch Feb 09

Is there a way to search:

Website * Events

and have all three of the above entries show?


Report •
Related Solutions


Ask Question