Solved

# Excel 2007 Survey Results Sort

Posted on 2012-09-05
272 Views
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
0
Question by:CMILLER

LVL 44

Expert Comment

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

LVL 24

Expert Comment

See attached example file...
ResultsFinal.xlsx
0

Author Comment

Q1.

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

I dont need the 0%'s
0

LVL 44

Expert Comment

If that's what the Asker wants it's a nice solution.
0

LVL 44

Expert Comment

TheBarMan has the cells formatted as Percent; just change it to Number.
0

LVL 24

Accepted Solution

Ammended file attached.
ResultsFinal.xlsx
0

Author Comment

I think What you updated in the file will be fine
0

Author Comment

What do I modify for my original 1700+ rows file
0

LVL 24

Expert Comment

Nothing, just pop more data into sheet 1
0

LVL 44

Expert Comment

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

LVL 24

Expert Comment

There is no need. no formatting.. though the TOTAL row formula needs correcting:

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

It was limited to first 11 rows
0

Author Comment

Cool, let me check it with all rows.
0

LVL 24

Expert Comment

Martin, on a side note: you hear about Dave?
0

LVL 44

Expert Comment

Who?
0

LVL 24

Expert Comment

Dlmille (Dave)
0

Author Comment

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

Author Comment

0

## Featured Post

### Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity anâ€¦
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article youâ€™ll learn how to use ExcelToWord! to copy data,charts, shapes â€¦
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.