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

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/...pivotstart.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"Melanie" wrote in message
thlink.net...
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