Well, we took the suggestions and put them to work. We're impressed. Sorted
and printed wonderfully. Saves a lot of hard work.

Appreciate the help.

Something else popped up during the evening which we didn't think of when
posing the first question.

The database with the several categories of skill levels contains male and
female of course! Column F contains the letter M or F to designate that. How
would a person build a formula that would combine the data from that column
as well as the information of the category in the other column?

IOW, the Excel has to search for two criteria. Any attempts of mine to build
such a formula just upset the computer. :-)



"cruncher" <wuss@unreal.net> wrote in message
news:11jajreaovilk90@corp.supernews.com...
> Friend of mine manages the membership list for a club, about 500 or so,
> using Excel as the program.
>
> It contains the usual; names, addresses, phone numbers, skill levels.
> Presently there are five levels.
>
> As can be expected, the list constantly changes with members moving to
> different levels, coming or leaving the club. There has to be periodic
> reports to the executive of the numbers in each category.
>
> I suggested adding a couple of blank lines after each category and using
> the CountA function to count the number of members in each category but
> I'm not very good at Excel either.
>
> The category beside each member is identified by A for advanced, I1, I2,
> I3 for intermediate levels and beg for beginner level.
>
> Can the formula be adapted to count the number of "a" etc. in the list?
>
> Another cell could be used to count the total membership.
>
> How would other users approach the task?
>
> Thanks
>