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