Remember Me?

#1
April 16th 05, 01:44 PM
 Alexa Posts: n/a
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
April 16th 05, 02:03 PM
 ΊΌΦέΘΛ Posts: n/a

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

#3
April 16th 05, 02:06 PM
 Bob Phillips Posts: n/a

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

#4
April 16th 05, 02:23 PM
 Posts: n/a

Hi Bob,

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

Alexa

#5
April 16th 05, 03:48 PM
 RagDyeR Posts: n/a

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

#6
April 16th 05, 03:59 PM
 Bob Phillips Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post RH Excel Discussion (Misc queries) 2 December 8th 06 03:21 AM Stephen Excel Discussion (Misc queries) 8 April 5th 05 01:22 AM Jig Bhakta Excel Worksheet Functions 4 February 3rd 05 04:01 AM Monk Excel Discussion (Misc queries) 3 December 10th 04 11:39 PM Ian Roberts Excel Worksheet Functions 2 November 7th 04 04:13 PM

All times are GMT +1. The time now is 02:00 PM.