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