Statistics - help needed

Hi,

I have some difficulties in producing statistics reports.

i.e. I have a column named Countries with a list of countries which occur more than once. I would like to get a stat report about the percentage of each country within the whole list.

Or, I would like to get a stat report regarding how two different columns affect the third one.

I would like to add that each column is filled with character data and not numeric one.

I would appreciate any help.

Thanks.

You could use a number of cells with COUNTIF() functions, But in your case a
pivot table is much easier. Make sure the first row above the country column
has a label in it. Then pull-down Data > pivot table report > click next on
the next two screens. On the third screen click Layout and you will see
three rectangular fields.

Drag your label into both the Row and Data rectangle (in the data area it
should say something like count of countries). Click OK and then click
finish.

In the resulting table just divide the total for each country by the grand
total and format as percentage.
--
Gary's Student


"Eligator" wrote:

>
> Hi,
>
> I have some difficulties in producing statistics reports.
>
> i.e. I have a column named Countries with a list of countries which
> occur more than once. I would like to get a stat report about the
> percentage of each country within the whole list.
>
> Or, I would like to get a stat report regarding how two different
> columns affect the third one.
>
> I would like to add that each column is filled with character data and
> not numeric one.
>
> I would appreciate any help.
>
> Thanks.
>
>
> --
> Eligator
> ------------------------------------------------------------------------
> Eligator's Profile: http://www.excelforum.com/member.php...o&userid=26958
> View this thread: http://www.excelforum.com/showthread...hreadid=401770
>
>