computing
  • 2

Solved Searching For Multiple Keywords in Excel

  • 2

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!

Share