Hi. This is my first ever post in any forum whatsoever so definitely new to this. I am in the need to find a way to identify the most recurring word or phase from the remarks field in excel. These remarks are given by customers as part of their open feedback to the organization in a questionaire i have designed. I have been able to analyze issues that I had locked as part of my drop down list on the analysis template using the countif and countifs formular. I have been able to cross reference data and narrowed down root problems. However, it is the open feedback that I would like analyze and the first thing I would like to do is to find the most recurring word and then the second and then the third and so on. Is there a way to do this in excel.

Appreciate the help.