Find most frequent occurring text in a column in Excel

The video offers a short tutorial on how to find most frequent occurring text in a column in Excel

[myrabbitispink]

this works great for when each cell only contains one word/ one reoccuring string of words and nothing else. however when you have different full sentences in each of your cells and try to filter out the most frequently used word across those it doesnt work any longer. any suggestions?

[chrissykora]

This isnt working with a drop down field

[JonLake-zbxf]

Cant get this to work on Google Sheets. Any ideas?

[timzelikovsky]

respects how do we get the number of times it occurs though?