Hello, I am analyzing a dataset that looks at health services provided and allows for multiple responses. Below is a snippet of the survey data I am working with (note Sites and Services are 2 different variables, as in the attached excel spreadsheet):
Sites Services
1 Primary care,Behavioral health: Mental health,Behavioral health: Substance use disorder,Dermatology,Chronic conditions
2 Behavioral health,Oral health,Primary care
3 Oral health
I would like to identify how many sites provide oral health, yet when I do countif(range,"Oral health"), it presents me with sites that only provide oral health, and when I do countif(range,"*Oral health*"), it provides me with count of oral and behavioral health. Thus, is there a way to count observations that is case sensitive? If not, I was thinking I would find and replace 'Oral health' with 'dental', but it seems this feature is also not case sensitive and thus replaces all instances (i.e. 'oral health' and behavi'oral health') with dental. Any guidance I can receive with this matter is greatly appreciated. Thank you very much.
Bookmarks