http://www.excel-easy.com/examples/most-frequently-occurring-word.html

Most Frequently Occurring Word

COUNTIF function to count the number of occurrences of each word.

The MATCH function returns the position of a value in a given range.

To find the position of the most frequently occurring word (don’t be overwhelmed), we add the MODE function

Use this result and the INDEX function to return the 2nd word in the range A1:A7, the most frequently occurring word.

**Two-column Lookup**

This example teaches you how to perform a **two-column lookup** in **Excel**. See the example below. We want to look up the salary of James Clark, not James Smith, not James Anderson.

1. To join strings, use the & operator.

#### Excel formula tutorial: How to use COUNTIF, SUMIF, or AVERAGEIF functions

Introduction

1. Formula and Function Tips and Shortcuts

2. Formula and Function Tools

3. IF and Related Functions

4. Lookup and Reference Functions

5. Power Functions

6. Statistical Functions

7. Math Functions

8. Date and Time Functions

9. Array Formulas and Functions

10. Reference Functions

11. Text Functions

12. Information Functions

Conclusion