Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My apologies; I can't yet post pictures so these are links to screencaps of my two worksheets:

Projects / Month by Month

As you may have guessed, I need to compile the data from the projects into a month by month summary, based on their respective start and end dates. I've looked into vlookup(), match() and offset()—it seems these functions may hold the key but it's a very complex task and I'm not really sure where to start. Is there a function (or set of functions) that's better suited for this kind of work? How would you tackle it?

Thanks, James

share|improve this question

You may want to have a look at pivot tables. These are ideal for aggregating large data sets, slicing, dicing, filtering, etc.

Get started with pivot tables here:

share|improve this answer
Thanks for the link! I had fiddled with PivotTables a little and ended up with an illegible mess, but I'll try to learn them properly. – jam Mar 1 '13 at 2:22

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.