Solved Searching for multiple keywords in Excel

May 24, 2012 at 11:02:12
Specs: Windows XP
I have a quite extensive xlsx worksheet containing medical providers and details about them, fx.
Column A: Last Names
Column B: First Names
Column C: Provider Type
Column D-H : Availablity
**Column I: Speciality**

I am only interested in searching the last column. I tried using the CTR+F option, however, this only allows me to search for one search term. Column I often contains several items separated by a commas, fx:

"pediatrics, obsterics, psychiatry"

I am interested in finding all the providers that match multiple search terms, fx. "Pediatrics" and "Psychiatry," does anyone know how I would go about doing this?

Thank you!


See More: Searching for multiple keywords in Excel

Report •


#1
May 24, 2012 at 11:54:01
✔ Best Answer
Will the answer in this thread help?

http://www.computing.net/answers/of...

You'll need to use the comma.

pediatrics, * psychiatry

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


Report •

#2
May 24, 2012 at 12:01:07
You are 5 shades of Awesome! Thank you - Yes, yes it does!

Also, do you know if there is a way to tell Find that order doesn't matter? In the above example, having it search for "pediatrician, *psychiatrist" and "psychiatrist, *pediatrician" at the same time?


Report •

#3
May 24, 2012 at 18:29:24
The order matters.

The only way to search for strings out of order would be to use some VBA code - a macro.

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


Report •

Related Solutions

#4
May 25, 2012 at 08:52:30
Yeah...that wouldn't work...too complex for my demographic. Thank you though! Your solution still solves around 80% of my problem.

If I alphabetize the lists, it shouldn't be a problem though :)


Report •

#5
May 25, 2012 at 08:59:42
You might also be able to do more if you split the different specialties into separate cells and then used the Advanced Filter feature.

See this thread:

http://www.computing.net/answers/of...

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


Report •


Ask Question