How can I setup a counter to count the number of times a
word appears in one column. The column I have contains
city names and I'd like another column to display the
number of times the City name appears.

Example...

Column 1 Column2 Column 3

Liverpool Liverpool= 3
Liverpool London= 2
Liverpool Edinburgh= 4
London
London
Edinburgh
Edinburgh
Edinburgh
Edinburgh

Any help would be muchly appreciated