Filtering in Excel 2007

K

Kyle

I am trying to take a large amount of data (300,000 lines) (List Range):

CUSTOMER INV DATE INVOICE SHIP DATE AWB
923793 4/25/2007 104102751 4/24/2007 104102751
923793 4/25/2007 104102762 4/24/2007 104102762

and sort out of it specific entries (2,000 lines) (Criteria Range):

AWB
104102751
104102762

How do I set up my query? Can I give it a column of data to look for in my
range?
 
Top