Strider119
New Member
- Joined
- Feb 15, 2008
- Messages
- 30
Hi, any help I can get with this would be much appreciated. I'm not good with the VB stuff but I figure it's the only way to do this.
I have a ton of data in two columns. First colum is a name, which is irrelivant to the problem, second column is a zip code.
What I need to do is to be able to tally up how many people are in a certain zip code. Is there any way Excel to read colum 2 and count how many individual points of data there are? Like something that can just feed into other cells and say "there are 345 entries for zipcode 00001 and 221 for zip code 00002 ... etc"
There is a lot of data too. At a cursory glance, there are 60 to 250 for each zip, give or take. Too many to count individually.
Again, I apprecaite any tips that I can get. Thank you.
I have a ton of data in two columns. First colum is a name, which is irrelivant to the problem, second column is a zip code.
What I need to do is to be able to tally up how many people are in a certain zip code. Is there any way Excel to read colum 2 and count how many individual points of data there are? Like something that can just feed into other cells and say "there are 345 entries for zipcode 00001 and 221 for zip code 00002 ... etc"
There is a lot of data too. At a cursory glance, there are 60 to 250 for each zip, give or take. Too many to count individually.
Again, I apprecaite any tips that I can get. Thank you.