Count how many times the same word appears in column

  • Thread starter Thread starter Alexa
  • Start date Start date
A

Alexa

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
 
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)
 
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 !
--------------------------------------------------------------------

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting and deleting 7
count how many times same names appear in a column 3
description of count in subtotal 1
counting words in Excel 3
counting how many of the same numbers 1
Counting Cells with same data 3
Specific words Categorizaion 1
How to sort entire spreadsheet by one column sort 5

Back
Top