G
Gigafreak
Hello Group
I am a new subscriber to the group and a fairly new Excel (2002) user.
What I would like to know is how can I count the number of occurences
of words in a column.
To explain what I mean I'll try and illustrate my worksheet and what I
am using it for.
In column G of each worksheet I have a list of places that have been
visited, this list is added to and each worksheet is a new month. The
list of place names may include place names and, of course duplicate
place names eg;
Bristol
Bath
Swindon
Exeter
Bristol
Cardiff
Newport
Bristol
What i would like to do is create in column H a result that shows the
number of times each place name occurs in that specific month. From
there I could probably work out how to create a chart to illustrate
the monthly/annual place visit statistcal reprosentation.
Any ideas comments would be greatly appriciated.
Craig
I am a new subscriber to the group and a fairly new Excel (2002) user.
What I would like to know is how can I count the number of occurences
of words in a column.
To explain what I mean I'll try and illustrate my worksheet and what I
am using it for.
In column G of each worksheet I have a list of places that have been
visited, this list is added to and each worksheet is a new month. The
list of place names may include place names and, of course duplicate
place names eg;
Bristol
Bath
Swindon
Exeter
Bristol
Cardiff
Newport
Bristol
What i would like to do is create in column H a result that shows the
number of times each place name occurs in that specific month. From
there I could probably work out how to create a chart to illustrate
the monthly/annual place visit statistcal reprosentation.
Any ideas comments would be greatly appriciated.
Craig