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?
You could use formulas like:
=countif(a:a,quot;cquot;)
Jim wrote:
gt;
gt; I have a column. The column can have a C or T or U or X. I want to count
gt; the number of each. How can I do this or is there a way?
--
Dave Peterson
=countif(A:A,quot;Cquot;) will count quot;Cquot;s in column A
quot;Jimquot; wrote:
gt; I have a column. The column can have a C or T or U or X. I want to count
gt; the number of each. How can I do this or is there a way?
Thanks. I will give it a try.
quot;Toppersquot; wrote:
gt; =countif(A:A,quot;Cquot;) will count quot;Cquot;s in column A
gt;
gt; quot;Jimquot; wrote:
gt;
gt; gt; I have a column. The column can have a C or T or U or X. I want to count
gt; gt; the number of each. How can I do this or is there a way?
Thanks, I will give it a t ry.
quot;Dave Petersonquot; wrote:
gt; You could use formulas like:
gt;
gt; =countif(a:a,quot;cquot;)
gt;
gt;
gt;
gt; Jim wrote:
gt; gt;
gt; gt; I have a column. The column can have a C or T or U or X. I want to count
gt; gt; the number of each. How can I do this or is there a way?
gt;
gt; --
gt;
gt; Dave Peterson
gt;
- Dec 25 Tue 2007 20:41
how do I get the frequency of letters in a column?
close
全站熱搜
留言列表
發表留言