Counting Zip Codes

[jennerifw]

I have a very long address list, with more than 50 different zip codes.
I would like for excel to count how many times each zip code appears.
Is there a way to do this with out entering all of the different zi
codes into the formula?

I also don't want to sort the list by zip code....I need it sorte
another way for my use.

Any ideas

 

[Ed Ferrero]

Hi jennerifw,

Use a pivot table. Have zip code as a row field and count of zip code as the
data field.
A tutorial on Pivot Tables if you need it is at
http://edferrero.m6.net/tutorials.shtml

Ed Ferrero
http://edferrero.m6.net/

 

[RagDyer]

Say the zip codes were in Column A.

Try this formula in any column:

=COUNTIF(A:A,A1)

And copy down as needed.

Now, you'll be displaying the same zip counts numerous times, but you will
see how many there are of each one.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[gls858]

I have a very long address list, with more than 50 different zip codes.
I would like for excel to count how many times each zip code appears.
Is there a way to do this with out entering all of the different zip
codes into the formula?

I also don't want to sort the list by zip code....I need it sorted
another way for my use.

Any ideas?

Another method would be to sort the list by zip code then do a subtotal
count on that sort. Data > Subtotals the rest is easy.

gls858