HELP: Counting frequency of a text

J

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
 
R

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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top