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