Counting case sensitive data
Posted by Rob Stone on February 13, 2002 8:15 AM
Hi,
I am trying to count a Column of data which is in Case sensitive format. For example, is there a command for searching and counting all the "h"'s in lower case and then all the "H"'s in upper case and display a total count for each?
Posted by Mark W. on February 13, 2002 8:18 AM
Are these h's part of a larger string? If so, are there more than 1 per sting? [nt]
Posted by Rob Stone on February 13, 2002 8:42 AM
Re: Are these h's part of a larger string? If so, are there more than 1 per sting? [nt]
**
The h's are a single character.
Cheers
**
Posted by Mark W. on February 13, 2002 8:54 AM
Re: Are these h's part of a larger string? If so, are there more than 1 per sting? [nt]
These array formulas would do the trick...
{=SUM(EXACT(A1:A10,"h")+0)}
{=SUM(EXACT(A1:A10,"H")+0)}
Note: Array formulas must be entered using the
Control+Shift+Enter key combination. The
outermost braces, {}, are not entered by you --
they're supplied by Excel in recognition of a
properly entered array formula.
Posted by Rob Stone on February 13, 2002 9:20 AM
Re: Are these h's part of a larger string? If so, are there more than 1 per sting? [nt]
:Thats sorted it. Thanks
