Getting count of entries in a column

P

Pawan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate entry in a column/row 14
VBA Macro to retrieve information from xml file 1
How to use comma separated inputs in macro 4
Excellent code now a question of Feasibility 7
Excel 2010/2007 - How much can be done with Custom Validation? 7
Creating hierarchy in excel 3
Replace cell values in multiple columns 3
Extracting data on multiple files from one folder 13

Top