Multiple answers

Joined: Dec 26, 2007 Posts: 2

I've got what is probably going to be an easy one for someone who knows Excel. I want to be able to pull all the matching information for given criteria from an Excel database; AND/OR the complete (or partial) records of all the data that match one or more other criteria. Obviously Index & Match won't do it. Pivot Tables seems like the logical answer, but I'm having trouble with it. Is MS Query the answer, and if so, how do I do it?

This is just practice for me (now), and while I'd appreciate an answer to a question with multiple answers, I'd also like to know where I can get some tutorials on Pivot Tables. I've googled it, and while I come up with a lot of explanations of how it works, there are no hard tutorials that take you by the hand and lead you, which is what I need.

Also, a source for other common, helpful Excel formulas for someone who at the beginner to intermediate skill level.

Thank you.

Joined: Jan 14, 2008 Posts: 12

The answer is to use a pivot table, or if you are feeling brave Shocked

, then use array formulas.

Array formulas can basically be used like a Sumif function but with multiple conditions. A good article is located here

Pivot tables are difficult to use in further calculations, and can be both unpredictable and buggy. Array formulas are fast to calculate and can be used in further calculations, but can start to do your head in while you are setting them up.