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

Two or more data sets that you want to plot on the same chart.
Even if you have two completely different scales, you can still show your data on a chart side-by-side.