How to Get Multiple Values Based on Criteria

[gall3on]

Without using Macros/VB, is there a formula that can filter a table by a specific field and grab all the 'returned' results from a different column and paste them in a different worksheet?

For Example:
Test Name Month Start
ABC 1
DEF 1
GHI 1
JKL 2
ACD 2

Using some formula (if it exists):
Month 1 Month 2
ABC JKL
DEF ACD
GHI

I need the formula to be dynamic enough to that it will update as I add tests to Table 1. I don't know if I'm making this more complicated, but I'm drawing a blank right now. I really don't want to use VB on this functionality. Is there an array formula with an offset function or dget function that I can use? I want it to act like DGET but instead of just returning 1 value, i want it to return anything that matches the criteria as an array (under the MOnths).

 

[SkipVought]

hi,

Check out the PivotTable Wizard.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]