View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bendinblues Bendinblues is offline
external usenet poster
 
Posts: 16
Default Need advance filtering to grab records that contain certain charac

I need to filter a large spreadsheet of over 1000 product/sku numbers to find
records that contain 200 product/sku numbers that i am interest in analyzing.
These are currently stored as a 9 digit number in the large spreadsheet.
What I need to do is to query on the first 6 digits of the 9 digits for the
200 product/skus that I am looking for. I'd like to extract the records and
save them to another workbook.