+ Reply to Thread
Results 1 to 5 of 5

How to receive an exact count from a list based upon unique upper/lower case characters

  1. #1
    Registered User
    Join Date
    03-12-2014
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to receive an exact count from a list based upon unique upper/lower case characters

    Hello-

    I am working sum up how many times a string of numbers and letters appear in a list of about 2,000 entries. My initial thought was to do a simple Countif function. However; my list contains strings such as:

    90989ABC
    90989abc

    So when I do a countif function - I am receiving a result of "2" for both "90989ABC" and "90989abc" where in actuality I need to formula to return a result of 1 because they represent 2 different types of records.

    As I mentioned, I have a list of about 2,000 entries that include a high number of duplicates - so I want to see how many times the entry is "A1" for example appears in the column A:A accounting for an exact match.

    Thank you!

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How to receive an exact count from a list based upon unique upper/lower case character

    Hi and welcome to the forum!

    Difficult to give you a definite answer since you don't attach a workbook and only give one example. Can I just ask: is case sensitivity the only issue preventing your COUNTIF solution from working?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: How to receive an exact count from a list based upon unique upper/lower case character

    One way to do that is by using the following array formula. Remember to confirm it with Ctrl+Shift+Enter

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Registered User
    Join Date
    03-12-2014
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to receive an exact count from a list based upon unique upper/lower case character

    The sumif worked! I knew it was something along those lines, just couldn't figure out the details. Thank you for your help!!!!!

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: How to receive an exact count from a list based upon unique upper/lower case character

    Glad to help you. Thanks for the feedback.
    If that takes care of your question, please mark your thread as solved.
    Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

+ 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. Replies: 11
    Last Post: 01-18-2014, 12:56 PM
  2. [SOLVED] Excel 2007 : Change Cell color based on upper of lower case
    By FDibbins in forum Excel General
    Replies: 3
    Last Post: 12-30-2011, 07:42 PM
  3. Upper and Lower case in a Count
    By CanMan12 in forum Excel General
    Replies: 5
    Last Post: 01-22-2007, 03:56 PM
  4. [SOLVED] Help w/ project. Counting upper and lower case characters in a cell.
    By triadiemus@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2006, 08:10 PM
  5. [SOLVED] Count the occurance of upper or lower case letters
    By Sivsy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-13-2005, 04:06 PM

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