COUNT unique letter in a column
This will give you the number of lower case a's in a range:
=SUMPRODUCT(LEN(A1:A100)-LEN(SUBSTITUTE(A1:A100,"a","")))/len("a")
If you want to ignore case, you can use:
=SUMPRODUCT(LEN(A1:A100)
-LEN(SUBSTITUTE(upper(A1:A100),upper("a"),"")))/len("a")
(Substitute is case-sensitive)
Adjust the ranges to match--but you can't use whole columns (except in xl2007+).
Brian wrote:
Howdy All,
I want to count the number of occurrences of a partipular letter in a column
Any help?
THanks,
Brian
--
Dave Peterson
|