Am using Excel 2003. I am trying to count the number of zip codes in a
column. I have already copied and pasted the zip codes into a separate sheet
in my workbook. I need to know how many 12345 zips, how many 12346 zips,
etc. So I want something like this as a result:

12345 2
12346 1
12347 3
12354 22

What I don't want is something like this:

12345 2
12345 2
12346 1
12347 3
12347 3
12347 3
(this is assuming that the list on the left is my original list of zip codes)

So, I need something to display the zips in one column (not necessarily the
original data column) and then the count of each occurance of the zip code.
I am trying to make a report to use with a bulk mailing. I keep thinking
that it's a countif statement, but I'm not having any luck. When I try a
pivot table (granted, I've only done a pivot table successfully on one other
project and it was a sum, so I could easily be doing this incorrectly) I only
get a count of all the zip codes in my column.
However, if all I can get is a count like in my example (whether with a
countif or with a pivot or with a nested statement), I can work with it.

Thanks in advance for any help.