Work out the percentage


M

malycom

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.
 
Ad

Advertisements

M

Mike H

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
 
D

Daryl S

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.
 
M

malycom

Many thanks

Worked a treat.

Daryl S said:
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.
 
Ad

Advertisements

M

malycom

Thanks Mike & Daryl - Problem is now sorted.

Thank you very much for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top