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!
https://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.