LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Gathering Comments from Survey Data

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:

Jan-07 5 5 3 3 4 4 Comments
Feb-07 4 3 5 5 4 3 Comments
Feb-07 3 2 3 2 3 4
Mar-07 1 5 5 5 5 5
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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling Comments out of a Survey Scott@CW Excel Discussion (Misc queries) 6 February 1st 07 10:01 PM
Colllecting Comments in a survey Scott@CW Excel Worksheet Functions 0 January 23rd 07 05:11 PM
Gathering Data from Another Workbook David Excel Discussion (Misc queries) 0 September 13th 06 11:35 PM
Gathering Survey data ajw150 Excel Discussion (Misc queries) 1 November 28th 05 01:06 PM
gathering data xak_tay Excel Discussion (Misc queries) 0 September 30th 05 06:18 AM


All times are GMT +1. The time now is 12:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"