I need help with coming up with a formula that will return the number of times a word or phrase that is repeated in a column that will show the word and phrase including the number of times it was repeated.

I know there's a formula to look up words but I don't want to input what the word is. I want excel to return the words and phrases automatically.

Is this possible?