Excel 2007 : Filtering out via a list

An easy way would be to add a helper column that returns TRUE or FALSE based on if product ID is found in your subset.

eg

Assuming your product Id column is column A and your the IDs you want to filter is listed in Sheet2 A1:A10,

Then in a new column of the data sheet enter formula like:

=ISNUMBER(MATCH(A2,Sheet2!$A$1:$A$10,0))

copied down.

Now filter for TRUE on this column.


To use Advanced Filter, make sure the title on Sheet2 listing the Product IDs is the same as the one in the Database... then while in the database select the table and invoke Advanced Filter, make sure your selected table is in the top field, the criteria field you need to point to the sheet2 table with header...