Count how many times the same word appears in column

1. 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

2. Re: Count how many times the same word appears in column

=countif(A:A,B1),if B1= you word

3. Re: Count how many times the same word appears in column

Copy down

Then sort by column B

--

HTH

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

"Alexa" <forums@discountcosmeticsguide.com> wrote in message
> 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

4. Re: Count how many times the same word appears in column

Hi Bob,

Excel displays an error when I type in the formula. What should I do?

Alexa

5. Re: Count how many times the same word appears in column

What's the error?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

<forums@discountcosmeticsguide.com> wrote in message
Hi Bob,

Excel displays an error when I type in the formula. What should I do?

Alexa

6. Re: Count how many times the same word appears in column

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)

<forums@discountcosmeticsguide.com> wrote in message
> Hi Bob,
>
> Excel displays an error when I type in the formula. What should I do?
>
> Alexa
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1