Count occurences of same zip codes

  • Thread starter Thread starter Outlook, eh?
  • Start date Start date
O

Outlook, eh?

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
 
This should work for you...

=COUNTIF(A$1:A$4,A1)/COUNT(A$1:A$4)

change the ranges and copy down to suit your needs... you can format the
column for Percentages to get the display the way you want.
 
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.
 
Back
Top