Learn how to a build a cloud-first strategyRegister Now

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

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
Asked:
CMILLER
  • 2
1 Solution
 
CMILLERAuthor Commented:
0
 
SteveCommented:
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
 
CMILLERAuthor 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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