Counting the # of occurances in a column

[Bill]

i have a spread with 7200 zip codes, not all unique. I
am just trying to find out how many times each zip code
appears so i can see where most of our business is
comming from... any suggestions?

 

[Andy B]

Hi

That sounds like a job for a Pivot Table. If you also have a column of the
amount that was spent, you can find out which zip spends the most too!
For an intro to pivot tables, have a look here:
http://peltiertech.com/Excel/Pivots/pivottables.htm

 

[Dave R.]

Here's a link to a post with a solution by C. Pearson that would count for
you the most frequently occuring zip code.

http://tinyurl.com/ytckn