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.
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
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