text : Frequency

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Hi,

I need to know how many time I have a stringA
StringB and a StringC in a column. I think frequency
is only for numbers. How can I do it with Strings?

So With the frequecies of each 3 strings,I will be
able to build a flowchart.

Thanks,

J
 
Jack

use COUNTIF

For example: =COUNTIF(A1:A200,B1) for a range in column A; adjust to
suit

or: =COUNTIF(A:A,B1) for all of column A

Regards

Trevor
 
You can also, sort the table by that column with the items
you want to count, then use the subtotal feature.

Data|Subtotal , for each change in "that column",
COUNT "that column".
 
Back
Top