Count occurences of same zip codes
Create a pivot table on the data - you can switch the results from 'count' to
'percent of total' to get both pieced you need. Use the wizard, and put the
zip code field in both the Row and Data areas.
--
Daryl S
"Outlook, eh?" wrote:
I am working on an in-house member density spreadsheet in Excel 2003/2007.
Here is the test data
14815
14815
14891
19880
I would like result to be:
14815 2 50%
14891 1 25%
19880 1 25%
Any help?
-B
|