finding percentages of a list of zip codes

  • Thread starter Thread starter turkishgolds
  • Start date Start date
T

turkishgolds

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.
 
suppose your data is in col A starting from cell A1, put following
function in cell B1 and copy it down.
=COUNTIF($A$1:$A$3000,A1)/3000
format the cells as percentage.

hope this would help
 
Back
Top