Need Help Summarizing Survey Results

[Melanie]

I have an Excel worksheet that tabulates survey results for about 100 questions.
There are over 100 responses for each question. The responses vary. Some
questions are Agree, Neutral, Disagree, some questions are 1 to 5, some
questions are A to D and there are several more varieties.

I need to summarize the results for each question. For example, Q1: 35 Agree,
15 Neutral, 75 Disagree, Q2: 5-1, 12-2, 37-3, 55-4, 24-5, Q3: 99A, 0B, 2C, 4D,
etc for 100 questions.

Appreciate any and all suggestions!

Melanie

 

[Ken Wright]

Depending on how it is tabulated, a Pivot table may be a good way to go. Debra Dalgleish has a
nice intro at the following link:-

http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm