View original (French)

Excel: Count the number of times a word appears

Solved
MathieuX88 -  
 Manael -
Configuration: Windows Vista / Firefox 3.6.3

Hello everyone,

First of all, I want to apologize for the title, but it's quite difficult to express what I want in so few words :) Especially since the data is confidential (which makes it even harder)

Here’s what I want to explain.

I have a database (with only words => very important). There are 2 columns. The first one contains words that appear only once (a column with remaining activities to be done). The second one has words that appear often (20 different values). Note that the first column has more than 600 activities.

I would like to find an easy way to know how many times each word appears (in the second column)

I know I could count them, but it's a list of words that changes from day to day => Indeed, as when a task is completed, the gain is replaced by "Ok"

So, as I read through my explanation, I feel like I've explained it poorly, but I hope you can help me

Thank you in advance

5 answers

  1.
    pépé35530 Posted messages 2951 Registration date   Status Member Last intervention   1 390
     
    Hello,

    You can use the function 
    =COUNTIF(range; criterion)


    You can also use a pivot table by selecting the items from your second column.
    Drag the category into the Rows area and also into Values area. It's quicker to do.

    See you later

    grandpa
    54
    1. jean-rachid++
       
      Thank you! It has greatly helped me in my intellectual journey. I will be eternally grateful to you!!! :)
      0
    2. Manael
       
      Great! I had the same issue.
      Thank you very much for this effective response!
      0