+ Reply to Thread
Results 1 to 4 of 4

Making COUNTIF Function Case-Sensitive for any string

  1. 08-12-2013, 01:27 PM #1
    p4carr
    p4carr is offline
    Registered User
    Join Date
    08-12-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2013
    Posts
    1

    Making COUNTIF Function Case-Sensitive for any string

    I have a range of regions and stores and I need to use COUNTIF to pull out a "1" for the regions and a "0" for the stores. So for one column I have a list of the regions only, and the other column has the regions and the stores underneath in a hierarchy. My dilemma is that some of the stores have the same name as the region, and the only way they differ is that the regions are lowercase and the stores are all caps. I have searched and searched, but could not find anything that meets what I need.

    Example:

    Albuquerque 1 Albuquerque Albuquerque
    Atlanta 0 ALAMEDA
    Augusta 0 CENTRAL SW
    Austin 0 GRIEGOS
    Birmingham 0 WYOMING
    Charleston 1 Atlanta Atlanta
    Charlotte 0 BANKHEAD
    Chattanooga 0 CONYERS
    Cincinnati 0 DORAVILLE
    Reply With QuoteRegister To Reply
  2. 08-12-2013, 05:15 PM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Making COUNTIF Function Case-Sensitive for any string

    Please take a look at the attached file:

    Formulas used in the spreadsheet must be entered as an array (Ctrl+Shift+Enter)
    Attached Files Attached Files
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  3. 08-12-2013, 05:25 PM #3
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Making COUNTIF Function Case-Sensitive for any string

    I'm not clear on how your data is set up but you can use EXACT function for a case sensitive match, so for example if you want to count instances of A1 in B2:B100.....but only if case matches then use this formula

    =SUMPRODUCT(EXACT(A1,B$2:B$100)+0)
    Audere est facere
    Reply With QuoteRegister To Reply
  4. 08-21-2013, 05:22 PM #4
    phaxman
    phaxman is offline
    Registered User
    Join Date
    08-21-2013
    Location
    East Bay, CA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Making COUNTIF Function Case-Sensitive for any string

    Thank you SO MUCH!!

    You Rock!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Making duplicate filter case sensitive
    By JustStep25 in forum Excel General
    Replies: 4
    Last Post: 01-12-2018, 02:59 AM
  2. making a formula case sensitive
    By icylemontea in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2014, 06:40 AM
  3. [SOLVED] non-case sensitive 'string' search?
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-25-2012, 03:01 PM
  4. how to make countif case sensitive
    By vsbhogar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-19-2012, 02:02 PM
  5. Making Excel Case Sensitive
    By spacecityguy in forum Excel General
    Replies: 4
    Last Post: 06-03-2009, 04:55 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1