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
|