Microsoft Office 2013 RT
Microsoft Office 2013 RT
I have a spreadsheet showing the results of survey. I need to copy all of the respondents who answered "Yes" to specific questions to their own spreadsheet, and then sort those respondents by what school they go to (selected from a drop down menu in the original survey). I'll need to do this multiple times for a variety of questions, because they will need to be visualized soon (e.g. 20% of students in the Art Department admitted to taking Adderall without a prescription).
我有一张显示调查结果的电子表格。我需要将回答“是”的所有回复者复制到他们自己的电子表格中的特定问题,然后根据他们去的学校对这些受访者进行排序(从原始调查的下拉菜单中选择)。我需要多次针对各种问题这样做,因为他们需要尽快形象化(例如,艺术部门有20%的学生承认在没有处方的情况下服用Adderall)。
How can I do this?
我怎样才能做到这一点?
1 个解决方案
#1
0
A classic case for a PivotTable, it would appear. Assuming data as in A1:G10, a PT (in I1, constructed as indicated) and double-clicking J8 should return (in a different sheet, but shown here in A13:G16, for the sake of the image):
它将成为数据透视表的经典案例。假设数据在A1:G10中,PT(在I1中,按照指示构造)和双击J8应该返回(在不同的表中,但在A13:G16中显示,为了图像):
The filtering options may be changed and double-clicking create further sheets with the relevant extracts.
可以更改过滤选项,然后双击使用相关提取创建其他工作表。
#1
0
A classic case for a PivotTable, it would appear. Assuming data as in A1:G10, a PT (in I1, constructed as indicated) and double-clicking J8 should return (in a different sheet, but shown here in A13:G16, for the sake of the image):
它将成为数据透视表的经典案例。假设数据在A1:G10中,PT(在I1中,按照指示构造)和双击J8应该返回(在不同的表中,但在A13:G16中显示,为了图像):
The filtering options may be changed and double-clicking create further sheets with the relevant extracts.
可以更改过滤选项,然后双击使用相关提取创建其他工作表。