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?
Bookmarks