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

A Pivot Table would be the most flexible way, and it's easy.

http://peltiertech.com/Excel/Pivots/pivotstart.htm

However, if you want to use Worksheet functions, enter your city names
in B1:Bx, then use:

C1: =COUNTIF(A:A,B1)

and copy down as far as required.


In article ,
"Paul" wrote:


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

Thanks man, worked a treat

-----Original Message-----
A Pivot Table would be the most flexible way, and it's
easy.

http://peltiertech.com/Excel/Pivots/pivotstart.htm

However, if you want to use Worksheet functions, enter
your city names
in B1:Bx, then use:

C1: =COUNTIF(A:A,B1)

and copy down as far as required.


In article ,
"Paul" wrote:


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
.