Frequency table

[Chris_b_84]

Hi is there anyway to build a frequency table of words in excel?
I've got about 4,000 to do and would like to build a table of the top few hundred, any help would be much appreciated.

*Chris

[Bryan Hessey]

Hi is there anyway to build a frequency table of words in excel?
I've got about 4,000 to do and would like to build a table of the top few hundred, any help would be much appreciated.

*Chris

Are the words 1 per cell (row?) - if so you can do a Countif to count each word within the range. You can suppress all but the first answer, and then Rank these counts.

=Countif(A1:A4000,A1)

will count all words (1 per cell) in column A, and, to suppress all but the first,

=If(Countif(A$1:A1,A1)>1,"",Countif(A$1:A$4000,A1))

should help

---