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.