Identify Common Phrases

[brsawvel]

Is there an option in excel to identify (and list the number of times) common phrases that appear in the worksheet?

My boss wants me to go through a worksheet of hundreds of customer feedbacks and identify the 10 most common complaints.

 

[chergh]

easier to use access for this. Import your data into access then create a query to count the number of records that a phrase appears in. You could do this in excel as well using the ado or dao library but if you don't know how to do this then I would go down the access path.

 

[HaHoBe]

Hi, brsawvel,

depending on the feedback (free text or a choice from Data/Validation?) you maybe could use TextToColumn and a pivot-table sorted descending (mind the 256 Columns up until Excel2003).

Ciao,
Holger

 

[georgedwilkinson]

You'd think there would be a free piece of software from google that would do that for you.