🚀 go-pugleaf

In <41030@sdcc12.ucsd.edu> fairchil@helix.ucsd.edu writes:

> 
> What am I missing?  I'm using Excel 4.0 to keep track of my students' grades. 
> I have a column of letter grades.  What I want to do is create a simple
> distribution; that is, tell me how many A's, how many B's, etc.  I have found
> two complicated ways to do this:  1) use the Crosstab plug-in (complicated,
> confusing, and slooooooow), or 2) use DCOUNT on a database *but* you can only
> do that for one grade at a time.  I can't believe that there isn't a simple
> function like HOWMANY(range,what_to_look_for).  What am I missing?
> 
> Kevin Fairchild

A year or so ago I did a macro sheet called "FREQ_ETC" for Excel 3.0.
These shareware macros might handle your needs. Here is part of the 
intro to it:
___
* * *  The * * * macro sheet will create a table
containing frequencies, rankings, and a rough estimate of
percentiles for each discrete value.  After the program creates
the table, it gives the user a menu in which portions of the
table can be selected or in which the user can command the
program to create to create a column chart or a pie chart.  Read
the documentation, which can be viewed by selecting FREQ_ETC
docs. under the Data menu.
___
I'll be glad to email the sheet bacause it is no longer available
at SUMEX(?)

Steve
--------------------------------------------------------------------------
    << The above are nothing more than my personal opinions >>
stephen r. white -- whitesr@appstate.bitnet -- whitesr@conrad.appstate.edu
--------------------------------------------------------------------------