Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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: http://peltiertech.com/Excel/Pivots/pivotstart.htm

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
add comment

Your Answer

 
discard

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.