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.


--
turkishgolds
------------------------------------------------------------------------
turkishgolds's Profile: http://www.excelforum.com/member.php...o&userid=36726
View this thread: http://www.excelforum.com/showthread...hreadid=564533

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

turkishgolds Wrote:
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.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=564533