Re: Variable number of multiple rows per record; want summary by record
- From: "jpdphd" <jimdilger@xxxxxxxxx>
- Date: 8 Aug 2006 21:11:16 -0700
TR
It looks like the sort of thing a pivot table could handle. It isn't
clear, tho, what the two columns after the names represent. Are they
different things (Wins and Losses) or the same (Bananas)?
Assuming that they are different, give each column a header. (eg Name,
Win, Loss)
Select all rows & columns with data (including header)
Data>PivotTable Report...
Step 1 - where is data? choose Excel list or database
Step 2 - should already show the range containing the data
Step 3 - where to put table, choose New Worksheet
click on Layout
Drag the "Name" label to the Row box
Drag the "Win" label to the Data box. It will say "sum of Win". Double
click "sum of Win"
Choose Average instead of sum. Format if you want.
Do same with "Loss".
Ok. Finish.
There are more bells and whistles, but this is the basic idea.
Just don't trust the "standard deviation" option (see my recent post).
If ColB and ColC are really the same sort of quantity (bananas), it can
still be done, but is a bit trickier. You have to display COUNT of each
column in the pivot table and do some math to find the overall average.
Too complicated for this post.
jpdphd
TR wrote:
Here's what the data look like
Pat 10 20
Joe 15 10
Joe 8 11
Kay 9 32
Pat 14 17
Joe 33 11
In short, each person has from 1 to n rows of data.. I want a summary
(probably on a different sheet) that shows the mean for each person.
The new sheet will have one row per person, showing the mean for each
data column for that person.
Suggestions?
TIA
.
- References:
- Prev by Date: Re: Excel 11.2.5 will not scale to fit
- Next by Date: Re: Column Width in Inches, Want Pixels
- Previous by thread: Variable number of multiple rows per record; want summary by record
- Next by thread: Re: Variable number of multiple rows per record; want summary by record
- Index(es):
Relevant Pages
|