asked on

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.

Chris Miller

ASKER

ResultsFinal-2.xlsx

ASKER CERTIFIED SOLUTION

Steve

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Chris Miller

ASKER

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.