Filtering in Excel 2007
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?
|