text : Frequency

[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

 

[Trevor Shuttleworth]

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

 

[KL]

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".