Analysis of Survey results (1000+ comments, 22k+ words)

**rdy4trvl** · 01-12-2009, 05:06 PM

I've downloaded about 1000 comments from bike riders in a large cycling event. The text comments were collected from from a survey and are in two separate groups (basically: What did you like most about the ride? and What should we improve?).

What I have done is run the text through a word count program to determine word frequency (http://rainbow.arch.scriptmania.com/...d_counter.html). So I know I have 250 favorable comments about the "food" served.

What I would like is to analyze each sentence for a particular word (say "food") and collect those sentences and provide those "food" comments to the chair person responsible for that particular area so they may improve the event for next year.

Any suggestions to ease/automate the task? (Without VBA which I don't know.) Thanks!

**stanleydgromjr** · 01-12-2009, 05:39 PM

rdy4trvl,

Welcome to the Excel Forum board.

If the 1000 comments are in column A (cell A1's title is "Comments"), you could use Data, Filter, AutoFilter.

Click on cell A1, and click on Data, Filter, AutoFilter
Click on the down arrow in cell A1
click on "Custom"
on the first box on the left, click the down arrow, and pick "contains"
on the box to the right, type in "food"
highlite all the rows that are displayed, and click on edit copy
pick another sheet, cell A1, and click on edit, paste special, "Values"

Have a great day,
Stan

**stanleydgromjr** · 01-12-2009, 05:40 PM

rdy4trvl,

Welcome to the Excel Forum board.

If the 1000 comments are in column A (cell A1's title is "Comments"), you could use Data, Filter, AutoFilter.

Click on cell A1, and click on Data, Filter, AutoFilter
Click on the down arrow in cell A1
click on "Custom"
on the first box on the left, click the down arrow, and pick "contains"
on the box to the right, type in "food"
highlite all the rows, below cell A1, that are displayed, and click on edit copy
pick another sheet, cell A1, and click on edit, paste special, "Values"

Have a great day,
Stan