I have a worksheet with a list of 3000 zip codes, many of them duplicates.

It looks something like this:

01060
01060
01060
01060
01060
01002
01002
01002
01002
01002

I'd like to generate data that tells me the percentages of how many times the zip codes appear in the list.

So, for the above example, I'd like to see this:

01060 50%
01002 50%

Easy enough, but I have 3000.

What do I do?

Thanks.