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.