finding percentages of a list of zip codes
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 |
finding percentages of a list of zip codes
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 |
All times are GMT +1. The time now is 07:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com