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