View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kyle Kyle is offline
external usenet poster
 
Posts: 66
Default 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?