Prev: SUMIF date criteria
Next: Sorting a text strings but omitting preceding "A" or "The"
From: Outlook, eh? on 15 Dec 2009 14:35
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
From: Rick Rothstein on 15 Dec 2009 14:53
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?" <Outlookeh(a)discussions.microsoft.com> wrote in message
news:237EFC19-9C96-4D4F-8D8F-5F503D5CDC32(a)microsoft.com...
>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

From: Daryl S on 15 Dec 2009 15:25
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
 | 
Pages: 1
Prev: SUMIF date criteria
Next: Sorting a text strings but omitting preceding "A" or "The"