+ Reply to Thread
Results 1 to 2 of 2

Help with case sensitive formulas

  1. #1
    Registered User
    Join Date
    04-08-2020
    Location
    Maryland, USA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1

    Help with case sensitive formulas

    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.
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,090

    Re: Help with case sensitive formulas

    Please try
    =COUNT(FIND("Oral health",B2:B4))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Case Sensitive
    By drew.parker in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2016, 11:32 AM
  2. Need to know complete list of case sensitive formulas
    By alchavar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2013, 01:26 PM
  3. [SOLVED] SUMPRODUCT Or SUMIF - In case of Case sensitive???
    By lifeisaspreadsheet in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-28-2012, 07:57 AM
  4. Input box case sensitive.
    By CJPHX in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2010, 06:19 PM
  5. Case Sensitive w/ IF
    By jeffP in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-05-2006, 09:20 PM
  6. [SOLVED] .Name case sensitive
    By CinqueTerra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2006, 05:00 PM
  7. Case Sensitive
    By hemants in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2005, 04:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1