Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I would suggest 3 tables.
Drop Site and Q1 into Row Fields and then drop QA into Data fields as well. Do the same in table 2 using Q2 instead, and table 3 with Q3... "Michael" wrote: Hi Folks - I have survey data like this: Site Q1 Q2 Q3 SiteA 1 3 2 SiteA 2 2 1 SiteA 2 1 3 SiteB 1 1 1 SiteB 2 1 3 etc. How can I use a pivot table to count the number of 1's, 2's and 3's for each question by site? Thanks for your help. Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Survey | New Users to Excel | |||
Analyze Survey Questions | Excel Worksheet Functions | |||
survey | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) |