Hello,

I have a column of text strings and blank cells and I'd like to develop cell formula #1 to display the most common string occurrence, and cell formula #2 to count the number of occurrences of a specific string in a separate cell.

Here's an example of the column of strings:


Harvard, Yale
Yale, UCLA
Berkeley
Yale
Harvard


And then the output table would look like this:

Most Common: Formula #1 returns "Yale"
Search: [Text Entry] = "Harvard"
# Occurrences: Formula #2 returns 2

I've found similar formulas to count repeating text strings, but none that have been able to count string recurrences within a cell (i.e. "Harvard, Yale").

Any help would be much appreciated!

-thegivenbeing