How to show percentage of words from a list?

[bigmark1972]

I have a large list of terms like shown below. Id like to know if there is a way to have it tell me what percentage of the total
number of words is each one For example;

visit website 32%
Visit Homepage 15%
Vicky Dryers 2%

Not sure if this can even be done but if possible would like some help.
The list of words would be similar as below.

VISIT WEBSITE
Visit Website
Visit Website
Visit Website
Visit Website
Visit Website
Visit Website
Visit Website
Visit Homepage
Visit Homepage
Visit Homepage
Visit Homepage
Visit Homepage
Visit bigmark1972's homepage!
Visit bigmark1972's homepage!
Visit bigmark1972\'s homepage!
Vicky Dryers
Vicky Dryers
Suzi Collins
Susan Silvers
Susan Silvers
Stella Porter
shotgun license application form
shotgun license application form
shotgun license application form
shotgun license application form
sell license
sell license
sell license
sell license
sell guns
sell guns
sell guns
sell guns

[Trebor76]

Hi ,

I can't reconcile back to your perentages, but nonetheless I think this is what you're after (just change the ranges to suit and fill down as required):

=COUNTIF($A$2:$A$35,A2)/COUNTA($A$2:$A$35)%

HTH

Robert

[Fotis1991]

Hi

One way, is this.

Format the cell with the formula, as Percentage(%) and use this formula.

=COUNTIF($A$1:$A$100;"visit website ")/10

Is this what are you looking for?

[jpr73]

Hi,
May be a variant with pivot table
The data are in table : automatically update when adding or deleting data
Don't forget to refresh the PT after new input in the table
The percentage count Visit Website is obtain with parameters value field
View values by column percentage and sorted from largest to smallest
Hope this helps
Best regards

[Marcol]

Try this, it extends Trebors' idea