| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting count of entries in a column
Hello I have an excel sheet with following data in column A: CA CA.SanFransisco CA.PLeasanton WV WV.Matinsburg There are hundreds of such entries in column A. I want to write a code which will tell me how many entries are there for each state. e.g. In the above case, I should get the result showing that CA has 2 entries and WV has 1 entry. Is this possible and how? Thanks in advance Regards, prm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting count of entries in a column | Excel Programming | |||
| Count entries in one column based on values in another column | Excel Worksheet Functions | |||
| How can I count the no. of entries in a column. | Excel Worksheet Functions | |||
| count duplicate entries in column | Excel Discussion (Misc queries) | |||
| How can I count the number of entries in a column? | New Users to Excel | |||
Linear Mode
