software

trying to tabulate several different text values automatically ie. ranks of
presonnel (private, sergeant, captain etc.) numbers or sergeants etc.

Take a look at either Pivot Tables (my choice), or the COUNTIF function.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------quot;automatically counting text cellsquot; lt;automatically counting text
gt; wrote in message
...
gt; trying to tabulate several different text values automatically ie. ranks
gt; of
gt; presonnel (private, sergeant, captain etc.) numbers or sergeants etc.