Hi there,

I have sentences in column A that contain many words separated by spaces. What I want is a table that tells me what the most frequently used word was in that column followed by the second most frequently used word and so on.

I have this array formula:

{=INDEX(A1:A1000,MODE(MATCH(A1:A1000,A1:A1000,0)))}

that does it for the whole cell value but I want to count words, and there might be multiple words in each cell. Thank you for your help it is much appreciated