Find the most frequent occurring word in Excel

The video offers a short tutorial on how to find the most frequent occurring word in a row or column in Excel.

[sumbalkhan]

can you help me, please? How can I find second most common word, third most common and so on up to 10 from a column in excel?

[socksamazingchannel]

when I do this for a column it's not returning anything (I changed the values for the column I want to check), any ideas?

[giandenorte]

thanks mate. this is what I exactly need.

[yanal]

thank you, exactly what i was looking for, now how to get the second most frequent occurring word

[jihhoupeh]

Thanks, but you've already type down your transcript, why not the formula. it's too small and shot to be seen,

[donatelodonatelo]

for multiple word which have the most frequency dont work))

[adurthyk]

can you please enter the function here

[sohagmily]

Thanks for this formula. How can i find most frequent word from multiple sheet in a row or column in excel? please suggest me..its so urgent.

[annielouise]

Thanks, now need to find the top 10 words out of 26819 words.... can someone help please?