A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Count how many times the same word appears in column



 
 
Thread Tools Display Modes
  #1  
Old April 16th 05, 01:44 PM
Alexa
external usenet poster
 
Posts: n/a
Default 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
Ads
  #2  
Old April 16th 05, 02:03 PM
ΊΌΦέΘΛ
external usenet poster
 
Posts: n/a
Default

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


  #3  
Old April 16th 05, 02:06 PM
Bob Phillips
external usenet poster
 
Posts: n/a
Default

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



  #4  
Old April 16th 05, 02:23 PM
[email protected]
external usenet poster
 
Posts: n/a
Default

Hi Bob,

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

Alexa

  #5  
Old April 16th 05, 03:48 PM
RagDyeR
external usenet poster
 
Posts: n/a
Default

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  
Old April 16th 05, 03:59 PM
Bob Phillips
external usenet poster
 
Posts: n/a
Default

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
>



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I count the number of times a particular charcter ("." say) RH Excel Discussion (Misc queries) 2 December 8th 06 02:21 AM
Count the number of times 1 happened in a row Stephen Excel Discussion (Misc queries) 8 April 5th 05 01:22 AM
Counting the number of times a word appears in a worksheet Jig Bhakta Excel Worksheet Functions 4 February 3rd 05 03:01 AM
Whats the function to count the total times a word is displayed Monk Excel Discussion (Misc queries) 3 December 10th 04 10:39 PM
How do I count how many times x appears in a column? Ian Roberts Excel Worksheet Functions 2 November 7th 04 03:13 PM


All times are GMT +1. The time now is 05:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright ©2004-2014 ExcelBanter.
The comments are property of their posters.