Hi

I have 1160 rows of client info with one column being the coutry in which a
client lives.

How can I work out the percentage of how many times a country appears in
that column. Ideally, I would like a formula that reads the colum, counts
the times a country appears and creates a list of the countries it found and
the percentage value of how many times it appears from the total. The
results could be in a new worksheet or within the same worksheet - It makes
no difference.
Thanks for your help.

Hi,

Two stages.

First to get a unique list of countries select the data then do an advanced
filter of unique items to a new location. I put the data in column B starting
in B1 for this formula which goes in C2 and is dragged down to get the
percentage.

=COUNTIF($A$2:$A$1160,B2)/COUNTA($A$2:$A$1160)

I assume your list has headers so I started in B2

Mike

"malycom" wrote:

Hi

I have 1160 rows of client info with one column being the coutry in which a
client lives.

How can I work out the percentage of how many times a country appears in
that column. Ideally, I would like a formula that reads the colum, counts
the times a country appears and creates a list of the countries it found and
the percentage value of how many times it appears from the total. The
results could be in a new worksheet or within the same worksheet - It makes
no difference.
Thanks for your help.

Malycom -

You can run a pivot table against your data, using only the Country field
for the row source and the count for the data area. You can set the data
area to show percentages of the total.

--
Daryl S


"malycom" wrote:

Hi

I have 1160 rows of client info with one column being the coutry in which a
client lives.

How can I work out the percentage of how many times a country appears in
that column. Ideally, I would like a formula that reads the colum, counts
the times a country appears and creates a list of the countries it found and
the percentage value of how many times it appears from the total. The
results could be in a new worksheet or within the same worksheet - It makes
no difference.
Thanks for your help.

Many thanks

Worked a treat.

"Daryl S" wrote:

Malycom -

You can run a pivot table against your data, using only the Country field
for the row source and the count for the data area. You can set the data
area to show percentages of the total.

--
Daryl S


"malycom" wrote:

Hi

I have 1160 rows of client info with one column being the coutry in which a
client lives.

How can I work out the percentage of how many times a country appears in
that column. Ideally, I would like a formula that reads the colum, counts
the times a country appears and creates a list of the countries it found and
the percentage value of how many times it appears from the total. The
results could be in a new worksheet or within the same worksheet - It makes
no difference.
Thanks for your help.

Thanks Mike & Daryl - Problem is now sorted.

Thank you very much for your help.

"malycom" wrote:

Hi

I have 1160 rows of client info with one column being the coutry in which a
client lives.

How can I work out the percentage of how many times a country appears in
that column. Ideally, I would like a formula that reads the colum, counts
the times a country appears and creates a list of the countries it found and
the percentage value of how many times it appears from the total. The
results could be in a new worksheet or within the same worksheet - It makes
no difference.
Thanks for your help.