I have the following list. I want VBA solution to get a count of first
7 characters.


List
03439061122
03439061122
03439061122
03449831122
03452401122
03455251122
03455251122
03455251122
03455251122
03455251122
03455691122
03457711122
03458331122
-----------------------------
Count
0343906 3
0344983 1
0345240 1
0345525 5
0345569 1
0345771 1
0345833 1
________________

Thx.