HELP: Counting frequency of a text

[jaong1]

Hi,

I s it possible to display the frequency of a particular data that is not
numeric by using a particular code or formula? eg. If I have the following:

me
me
me
me
you
you

And I want to find how many times me appears in the row, what should I do to
get the frequency without manually counting or looking at the numbers on the
first column?

Please help

 

[Rob Giordano \(Crash\)]

Excel question? This is a FrontPage newsgroup.

But;

=COUNTIF(A1:A6,"me")
=COUNTIF(A1:A6,"you")

well, that's for a column but you can adjust if for a row



--

Rob Giordano
Microsoft MVP - FrontPage





| Hi,
|
| I s it possible to display the frequency of a particular data that is not
| numeric by using a particular code or formula? eg. If I have the
following:
|
| me
| me
| me
| me
| you
| you
|
| And I want to find how many times me appears in the row, what should I do
to
| get the frequency without manually counting or looking at the numbers on
the
| first column?
|
| Please help

 

[choquette.pierre]

Hi,

I s it possible to display the frequency of a particular data that is not
numeric by using a particular code or formula? eg. If I have the following:

me
me
me
me
you
you

And I want to find how many times me appears in the row, what should I do to
get the frequency without manually counting or looking at the numbers on the
first column?

Please help