jsn_dacruz
New Member
- Joined
- May 18, 2011
- Messages
- 1
I'm quite new to Excel, but need to use it heavily for my new job. To make matters worse, I am using Excel 2003, which I am less familiar with. There are two specific problems I am encountering.
1) This is hopefully easy -- if I have a number of cells in a column, and I want to divide them all by a number, how do I go about doing so?
2) I have a large set of data and I need to do cross tabulations using Pivot Tables. It's easy enough for most of the data, but there are a few computations that are giving me trouble.
The data comes from a set of survey responses. The problem is, some questions had a 'check all' that apply feature. So Q1 answers may have options a, b, c, and d, some people chose a,b, other a,c, and other a only. Q2 may be similar, with options 1, 2, 3.
How do I create a pivot table So that I can see how many people that chose a (regardless of whether or not they chose just a, or a,c, or a,b,c etc.) also chose 1 (regardless of whether they chose just 1, or 1,2,3, of 1,3, etc.)
For most of the tables, I can just drag the data into the data area of the pivot table, and the other question (which does not have a 'check all' feature), can take up the column area. The break down is simple enough. If I try to do it this way with a 'check all' example, Excel gives me all the different combinations -- it kind of looks like a big March Madness bracket.
Please help! Any and all tips/ideas are much appreciated.
1) This is hopefully easy -- if I have a number of cells in a column, and I want to divide them all by a number, how do I go about doing so?
2) I have a large set of data and I need to do cross tabulations using Pivot Tables. It's easy enough for most of the data, but there are a few computations that are giving me trouble.
The data comes from a set of survey responses. The problem is, some questions had a 'check all' that apply feature. So Q1 answers may have options a, b, c, and d, some people chose a,b, other a,c, and other a only. Q2 may be similar, with options 1, 2, 3.
How do I create a pivot table So that I can see how many people that chose a (regardless of whether or not they chose just a, or a,c, or a,b,c etc.) also chose 1 (regardless of whether they chose just 1, or 1,2,3, of 1,3, etc.)
For most of the tables, I can just drag the data into the data area of the pivot table, and the other question (which does not have a 'check all' feature), can take up the column area. The break down is simple enough. If I try to do it this way with a 'check all' example, Excel gives me all the different combinations -- it kind of looks like a big March Madness bracket.
Please help! Any and all tips/ideas are much appreciated.
