|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?