What is the function of the most frequently occurring word in Google Sheets?

Question

Google Sheets

I've been looking for an answer to my question for the second hour, but either I'm blind or there is no such function. That's the question:
How to make it so that the most frequent word in the column is written in a separate cell?
A similar thing can be done with =countif , but it counts the number of these words in the list, and I need to make it so that this most frequent word is written. Thanks in advance.

Answer 1

If primitive, then you can do this: a demo table , but I would rather do it with a script
1) Break it into words
2) Combine the arrays into one
3) We consider the words unique
4) We are looking for the maximum