I am using Excel 2007 with survey results and would like to sort them by
question. There are 6 worksheets of data: one per campus with approximately
50 questions in the survey and 40 replies per campus. It is too cumbersome to
manually perform all these steps. I have the questions separated by column
and the answers are numerical ratings. I would like to sort these answers by
column independently without regard for the other columns. I would also like
to determine the percentage of those who answered 1, 2, 3, etc. Is there any
way to do this?
Thanks,
teacher2010

Sometimes key thoughts behind analysis work lie in preparing the source data.
If source data is identically structured in each data sheet, just stack it
all up into a single sheet with a single row of col headers. Do a manual copy
n paste from each data sheet to stack it in any sequence, a couple of minutes
effort will do it. Include a new col to differentiate the answers by campus,
eg: Campus1, Campus2, etc. Easily drag to fill down the campus name from the
1st cell aligned with the 1st row of each data section after you paste it.
Now you can easily do pivot table analysis on the combined source, or use
formulas in another sheet to dissect/analyse the data
--
Max
Singapore
---
"teacher2010" wrote:
I am using Excel 2007 with survey results and would like to sort them by
question. There are 6 worksheets of data: one per campus with approximately
50 questions in the survey and 40 replies per campus. It is too cumbersome to
manually perform all these steps. I have the questions separated by column
and the answers are numerical ratings. I would like to sort these answers by
column independently without regard for the other columns. I would also like
to determine the percentage of those who answered 1, 2, 3, etc. Is there any
way to do this?