Counting Zip Codes
 

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?


--
jennerifw
------------------------------------------------------------------------
jennerifw's Profile: http://www.excelforum.com/member.php...o&userid=26071
View this thread: http://www.excelforum.com/showthread...hreadid=400629

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/


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?


--
jennerifw
------------------------------------------------------------------------
jennerifw's Profile:
http://www.excelforum.com/member.php...o&userid=26071
View this thread: http://www.excelforum.com/showthread...hreadid=400629

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!
==============================================


"jennerifw" wrote
in message ...

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?


--
jennerifw
------------------------------------------------------------------------
jennerifw's Profile:
http://www.excelforum.com/member.php...o&userid=26071
View this thread: http://www.excelforum.com/showthread...hreadid=400629

jennerifw wrote:
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