Count occurrences of words in a list

  • Thread starter Thread starter Max Voegler
  • Start date Start date
M

Max Voegler

Hi all,

I have a worksheet that has a long list of terms entered into the search
window of our website (taken from a log file). I'd like to be able to create
a list of which words were used most frequently. I assume that come form of
the frequency function might do the trick, but I soon stumbled while trying
to write the function. Can anyone help?

Best, Max
 
Hi Max
one way (if each word is a separate cell in one column): Use a pivot
table for this:
- as row item use the word name column
- as data item use 'count of word item'
 
Max,

I don't think that the frequency function will be of much help, since (as
far as I know) this function works well on numbers only.
Most likely you will be better off with the countif function.
(Provided your arguments (the words) are stored in A1:A1000, in B1 enter
=COUNTIF($A$1:$A$1000,A1) and copy it down to B1000).

This will give the number of occurences of each word. With Max(B1:B1000)
or Large(B1:B1000,1) you can find the max of this numbers.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top