Tamizh Tech Tutorial

Word Frequency in Excel  

   

   

In this tutorial, you will learn and find how to count words in excel. Follow the steps below

Step 1:

• Extract the input words using unique function

• =unique(input range)

Step 2:

• Apply the builtin formula named countif(range, condition) for the obtained unique words using unique() function from step 1

• Display the result.

Example - Word Count in Excel

1. Input

2. Extract the unique words using unique()

=UNIQUE(H11:H26)

3. Result

=COUNTIF(H11:H26,I11)

• The function above is used to display the word frequency based on the condition.

Tamizh Tech Tutorial