Tabulating Multiple Surveys in Excel
 

You need to do two things:

1. organize your data in Excel
2. analyze the data after it has been entered

Let's make every row correspond to a question from a survery.

Column A will be the Group ID, column B will be the question ID, and column
C will be the response for the question. For example, if the first survey is
from group #8, then the data in columns A & B & C from A2 thru C51 would look
like:

8 1 A
8 2 B
8 3 A
8 4 D
8 5 C
8 6 A
8 7 E
8 8 F
8 9 A
8 10 A
8 11 D
8 12 D
8 13 E
and so on
The next survey will start in A52
In A1 thru C1 put column titles:

GROUP QUESTION RESPONSE

Then complete filling in the data.

Finally create a Pivot Table showing the sum of RESPONSE by GROUP by
QUESTION. For Pivot Table tutorials see:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student
gsnu200712