Enter the list of SKU on a worksheet, and name the range, e.g. SKUList
For the criteria formula, use:
=COUNTIF(SKUList,D2)

Bendinblues wrote:
Debra,

Thanks for the suggestion. The one problem is that the SKUs are not all SKUs
within a range of SKUs. in you example i might only want 200000, 210000,
250000, and so on. Would i need to setup a separate row for each SKU so that
Excel will us or?

"Debra Dalgleish" wrote:


In the workbook with the product records, create a criteria area with a
blank heading cell, and a formula in the cell below.
For example, if the SKUs are in column D:

=AND(--LEFT(D2,6)=200000,--LEFT(D2,6)<300000)

Change the 200000 and 300000 to match the range of SKU you want to extract.
Activate the workbook where you want the filtered records to go.
Then, run the Advanced Filter, and select the blank heading cell, and
the cell with the formula, as the criteria range.

Bendinblues wrote:

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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html