Mutiple outputs from different colums

[jonahbosworth]

I am working on a table and I need to seach an entire column, G for vaules ">=10" and then list the multiple task orders from column D

Here is how it looks
CHEM 04/15/13 04/16/13 52465150-03 CHEMISTYPERFOMSAMPLE EMH21 5
CHEM 04/15/13 04/16/13 52464550-02 CHEMISTYPERFOMSAMPLE EMH22 1
CHEM 04/15/13 04/16/13 52459750-03 CHEMISTYPERFOMSAMPLE EMH23 15
CHEM 04/15/13 04/16/13 52459850-03 CHEMISTYPERFOMSAMPLE EMH24 10
CHEM 04/15/13 04/16/13 52465150-03 CHEMISTYPERFOMSAMPLE EMH25 6
CHEM 04/15/13 04/16/13 52456850-03 CHEMISTYPERFOMSAMPLE EMH26 11
CHEM 04/15/13 04/16/13 52465150-03 CHEMISTYPERFOMSAMPLE EMH27 3
CHEM 04/15/13 04/16/13 52446850-03 CHEMISTYPERFOMSAMPLE EMH28 32


Here is what i was hoping for
Tasks Great than 10
Count 4
Task Orders
52459750-03 15
52459850-03 10
52456850-03 11
52446850-03 32


This table has over 300 entries and can very from week to week so I need it be open ended or at least to handle 500 rows. got the count if done, but tried using vlookup and index match and still not working. Any help?