LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Advance Filter + Unique Records tqm1 Excel Discussion (Misc queries) 3 July 5th 07 07:05 AM
Filtering out old records. david.palmer Excel Discussion (Misc queries) 1 March 24th 06 04:20 PM
advance filtering [email protected] Excel Discussion (Misc queries) 3 February 28th 06 04:24 PM
Advance filtering with multiple conditons falloutx Excel Discussion (Misc queries) 3 January 21st 06 07:28 PM
Filtering Records GregOnline Excel Worksheet Functions 1 October 21st 05 05:17 AM


All times are GMT +1. The time now is 04:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"