ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   COUNT SEVERAL TEXT VALUES AUTOMATICALLY (https://www.excelbanter.com/excel-worksheet-functions/68357-count-several-text-values-automatically.html)

automatically counting text cells

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

Ken Wright

COUNT SEVERAL TEXT VALUES AUTOMATICALLY
 
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 :-)
------------------------------*------------------------------*----------------


"automatically counting text cells" <automatically counting text
wrote in message
...
trying to tabulate several different text values automatically ie. ranks
of
presonnel (private, sergeant, captain etc.) numbers or sergeants etc.





All times are GMT +1. The time now is 03:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com