View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

In B1, add =COUNTIF($A:$A,A1)
Copy down

Then sort by column B

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alexa" wrote in message
om...
Hello,

I have a long list of about 50,000 words in column A. Some of these
words are the same.

I want to know the exact number of times each word appears in the A
column.

And I want to sort these words based on how many times they appear in
the A column.

How can I do that?

Alexa