Count how many times the same word appears in column
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 |
Answer: Count how many times the same word appears in column
Hi Alexa,
You can easily count how many times the same word appears in a column in Microsoft Excel by using the COUNTIF function. Here are the steps:
That's it! You now have a sorted list of words with their corresponding counts. Let me know if you need any further assistance. |
=countif(A:A,B1),if B1= you word
|
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 |
Hi Bob,
Excel displays an error when I type in the formula. What should I do? Alexa |
What's the error?
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- wrote in message oups.com... Hi Bob, Excel displays an error when I type in the formula. What should I do? Alexa |
Hi Alexa,
The formula works okay for me. Give us some details of the way you added it, the error and your data. -- HTH RP (remove nothere from the email address if mailing direct) wrote in message oups.com... Hi Bob, Excel displays an error when I type in the formula. What should I do? Alexa |
All times are GMT +1. The time now is 04:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com