Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2007
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Counting upper and lower case cell entries (Excel 2003)

    Is it possible to count the number of upper and lowercase cell entries? See attached spreadsheet for example.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Counting upper and lower case cell entries (Excel 2003)

    The following formulas are array formulas, i.e. they must be confirmed with Ctrl+Shift+Enter:

    =SUM(1*EXACT(A1:A12,LOWER(A1:A12)))

    =SUM(1*EXACT(A1:A12,UPPER(A1:A12)))

    EXACT compares two strings, case-sensitive. The result is TRUE or FALSE. Multiplying by 1 forces this to be interpreted as numbers 1 and 0.

  3. #3
    Star Lounger
    Join Date
    Jan 2007
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting upper and lower case cell entries (Excel 2003)

    Thank you. Your help is much appreciated and you have saved me hours of work!

Posting Permissions

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