Excel 2007 Survey Results Sort

Hi, I have a 2007 Excel worksheet that has raw data from a survey and I need help sorting it.

See the attached. I need to have the % for each question by the number.

1 = No
2 = Rarely
3 = Sometimes
4 = Often
5 = Always

I actually have over 1700 rows, I only included the first 10.

-Thanks.
ResultsFinal.xlsx
CMILLERAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
SteveConnect With a Mentor Commented:
Ammended file attached.
ResultsFinal.xlsx
0
 
Martin LissOlder than dirtCommented:
I need to have the % for each question by the number
I'm not sure what that means. Could you please show an example of the output you'd like?
0
 
SteveCommented:
See attached example file...
ResultsFinal.xlsx
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
CMILLERAuthor Commented:
Q1.

1=0%
2=0%
3=0%
4=30%
5=70%

I dont need the 0%'s
0
 
Martin LissOlder than dirtCommented:
If that's what the Asker wants it's a nice solution.
0
 
Martin LissOlder than dirtCommented:
TheBarMan has the cells formatted as Percent; just change it to Number.
0
 
CMILLERAuthor Commented:
I think What you updated in the file will be fine
0
 
CMILLERAuthor Commented:
What do I modify for my original 1700+ rows file
0
 
SteveCommented:
Nothing, just pop more data into sheet 1
0
 
Martin LissOlder than dirtCommented:
You'll need to change the formatting of the cells in the sheet to match the formatting in the solution. And of course use the same formula.
0
 
SteveCommented:
There is no need. no formatting.. though the TOTAL row formula needs correcting:

=COUNTIF(Sheet1!$A:$AA,Sheet2!$A2)/COUNT(Sheet1!A:AA)

Open in new window


It was limited to first 11 rows
0
 
CMILLERAuthor Commented:
Cool, let me check it with all rows.
0
 
SteveCommented:
Martin, on a side note: you hear about Dave?
0
 
Martin LissOlder than dirtCommented:
Who?
0
 
SteveCommented:
Dlmille (Dave)
0
 
CMILLERAuthor Commented:
I added the new formatting works great. I just noticed that I left out some other sorting. I will post another question. I need to sort by Org and department.
0
All Courses

From novice to tech pro — start learning today.