Count occurences of same zip codes

[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

 

[Rick Rothstein]

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.

 

[Daryl S]

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.