View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian H Brian H is offline
external usenet poster
 
Posts: 12
Default Gathering Comments from Survey Data

Drat, new update...
The data table has changed. Each row will now include a name on it.
We will be needing to limit by the names. (I guess I missed a memo)

"Brian H" wrote in message
news:4B7Eh.1138344$R63.177466@pd7urf1no...
I have raw survey data in a table on a single sheet. The data is the month
the survey was done followed by a few survey ratings then a comment. Some
surveys come back with out a comment so those lines are just the month and
the question data. Example:


Edited Data
Bob Jan-07 5 5 3 3 4 4 Comments
Bob Feb-07 4 3 5 5 4 3 Comments
Bill Feb-07 3 2 3 2 3 4
Bob Mar-07 1 5 5 5 5 5
Bill Mar-07 2 3 4 3 4 3 Comments


The months are Dates, the first of each month to be exact and the Comments
are unlimited (at this time) text fields.
I have a summary sheet that is showing the totals by month running across
the sheet. What I would like to do is gather the Comments under the
summary running down other then using a pivot table. When I did use a
table it stretched the summary table out of whack. Even if I can only show
one month at a time it would be OK.

Thanks for your time and thoughts!