Counting Zip Codes

A

alexm999

I have data ascending in column C and its populated by zipcodes. I have
a task that needs to find out which zipcodes occur the most frequent
in the column. I can manually go through 200+ different zipcodes (all
different) but it would take me several days.

Anyone help me with this?
 
E

eluehmann

are you familiar with pivot tables? A pivot table would be able to giv
you teh count of each zipcode in your sample. I have found pivot table
as very hard to explain to people. If you do a search I am sure ther
is a good write up of how to do one. If I can be of assistance pleas
ask
 
D

David McRitchie

That probably makes more sense then you can have
a column for first 3 digits and one for first 5 digits, and
you would be pretty much set up to have the state code
above the zip code if it is in your data..
 
Top