Solved

# Excel 2007 Survey Results Sort

Posted on 2012-09-05
249 Views
Please mod the attached to include the following.

Q15 ( Employee Type )
1=EmpType1
2=EmpType2
3=EmpType3
4=EmpType4

Q16 ( Org )
1=Org1
2=Org2

Q17 ( Q16-Org1 + Department )
1-54

Q18 ( Q16-Org2 + Department )
1-40

Thanks.
0
Question by:CMILLER

Author Comment

0

LVL 24

Accepted Solution

Could you provide a little more detail on the desired result.
I am not sure how you would like the output.

The attached has my "best guess"
ResultsFinal-2.xlsx
0

Author Comment

Sorry, I guess that was a little vague.

I need it sorted by Q16 (Org1), Q17 (D-1), Q15 (Employee type 1-5)

So, SheetX would have Org1, D-1, ET-1 for Q1-Q12
Either on the same SheetX or another SheetX would have Org1, D-2, ET-1 for Q1-Q12 etc...

Example:
**********************************************
Org1, D-1, ET-1 for Q1-Q12
Org1, D-1, ET-2 for Q1-Q12
Org1, D-1, ET-3 for Q1-Q12
Org1, D-1, ET-4 for Q1-Q12

then

Org1, D-2, ET-1 for Q1-Q12
Org1, D-2, ET-2 for Q1-Q12
Org1, D-2, ET-3 for Q1-Q12
Org1, D-2, ET-4 for Q1-Q12

then do all for Org1, D3-D54

Then do all the same for Org2
***************************************************
Q15 ( Employee Type )
1=EmpType1
2=EmpType2
3=EmpType3
4=EmpType4

Q16 ( Org )
1=Org1
2=Org2

Q17 ( Q16-Org1 + Department )
1-54

Q18 ( Q16-Org2 + Department )
1-40

If you can think of a better way to break out the example, if not tell me how and I will create all the above example. At some point I need to make a chart that breaks it out like the example, unless you think it would be easier to just do that instead.
0

## Featured Post

### Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
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 …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.