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