M
Michael
Hi Folks - I need to provide counts and percentages of survey data. If
Question 1 has 5 possible answers (1,2,3,4,5), then i need to count how many
1's, 2's, etc., plus calculate the percentage of the counts to the total
number of answers.
The data looks like this:
Q1 Q2 Q3 ...... etc.
1 2 5
2 3 2
5 1 4
etc.
In the past, I have inserted a blank column between the questions, then used
COUNTIF to count the answers in the Question column, and I have used the
blank column to calculate the percentages. It takes a awhile to setup, so I
was hoping there might be a better way using a pivot table. Any ideas?
Thanks.
Michael
Question 1 has 5 possible answers (1,2,3,4,5), then i need to count how many
1's, 2's, etc., plus calculate the percentage of the counts to the total
number of answers.
The data looks like this:
Q1 Q2 Q3 ...... etc.
1 2 5
2 3 2
5 1 4
etc.
In the past, I have inserted a blank column between the questions, then used
COUNTIF to count the answers in the Question column, and I have used the
blank column to calculate the percentages. It takes a awhile to setup, so I
was hoping there might be a better way using a pivot table. Any ideas?
Thanks.
Michael