In this lesson you can learn some trick - how to count repeated words. I implemented word counter and would like to share it with you.
There is a task. How to count repeated words in a cell?
For example you have some word (e.g. aa) which repeats many time in one cell.
How to count it?
Use that function:
=SUM(LEN(A1)-LEN(SUBSTITUTE(A1;"aa";"")))/LEN("aa")
Word counter worked. There are 9 "aa" words Counting Repeated Words in a Cell worked!