Learn how to a build a cloud-first strategyRegister Now

x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 259

# Excel 2007 Survey Results Sort

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
CMILLER
• 2
1 Solution

Author Commented:
0

Commented:
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 Commented:
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

• 2
Tackle projects and never again get stuck behind a technical roadblock.