Excel: Tell me what I can do with this information

For the last 2 months I have been tracking the statistics for my fantasy baseball league each week. I have a separate file for each week, so I can see who is making advances week-to-week, and who is doing worse.

But I think that I’m underutilizing the powers of Excel by creating separate files, so I compiled all the info into one file, with each week on a separate worksheet. What do I do now? There has to be some sort of nifty graph that’s easy to create using information across several worksheets, no?

Oh, a problem I see is the fact that some players don’t make the cut week to week. For instance, when I rank by name, some players that just didn’t have enough stats to warrant being copied weren’t included, when maybe they’re included in a different week. Is that a problem?

Three words: Pivot Table Report

Learn it. Know it. Love it.

:wink:

I’m going to need all my data on one worksheet for that then, aren’t I?

Yes, but it’s very easy to combine and summarize data from several different Excel lists. Just make sure the lists have matching row and column names for items you want to summarize together.

Pivot Tables (and Pivot Charts) are so awesome. You can work magic with them. :wink:

Still having problems. Let’s see if you can help me out. Let’s say I have consolidated the (simplified) info into the following:



NAME    DATE   TOTAL
Adams   5-1    20
Adams   5-8    50
Adams   5-20   100
Clark   5-8    35
Deano   5-1    15
Deano   5-8    30
Deano   5-13   45
Deano   5-20   60
Smith   5-13   25
Smith   5-20   100


Two problems that I have:

  1. I’m not supposed to use formulas, but TOTAL is a formula. But without it, this exercise is pointless (each category is worth a certain number of points).

  2. The totals are cumulative. Totals from 5-13 are included in totals for 5-20. The PivotTable wants to add them together (giving Smith 125).

Thanks for your help so far, K_G.