how do I get the frequency of letters in a column?

Jim · Mar 29, 2006

I have a column. The column can have a C or T or U or X. I want to count
the number of each. How can I do this or is there a way?

Dave Peterson · Mar 29, 2006

You could use formulas like:

=countif(a:a,"c")

I have a column. The column can have a C or T or U or X. I want to count
the number of each. How can I do this or is there a way?

Toppers · Mar 29, 2006

=countif(A:A,"C") will count "C"s in column A

Jim · Mar 29, 2006

Thanks, I will give it a t ry.

Dave Peterson said:
You could use formulas like:

=countif(a:a,"c")