Count occurences of same zip codes
 

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

Count occurences of same zip codes
 

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.

--
Rick (MVP - Excel)


"Outlook, eh?" wrote in message
...
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

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