I have a stock-list of books and would like to filter the stock data only with selected publishers.

Is there a way I can provide a 'comma separated list' in the filter?

enter image description here

I tried the 'Advanced filter' option but it didn't really work. What options do I have?

I am using Excel 2007 and some sample data:

ISBN, Title, Publisher, Qty, Price
123213, Title1, Publisher 1, 10, 100
123213, Title1, Publisher 1, 15, 100
143213, Title1, Publisher 3, 16, 10
126213, Title1, Publisher 8, 10, 50
126213, Title1, Publisher 10, 17, 100

The advanced filter I tried is:

enter image description here

  • 1
    You are nearly there. The advanced filter is exactly the right choice. What Excel version are you using? Maybe you can also edit your question with some sample data. Then we can show you, how to setup the advanced filter.
    – nixda
    Jul 1, 2013 at 9:33

1 Answer 1


How to use Advanced filter

  1. Setup the criteria range. Make sure, your criteria head and the data table head to filter are exactly the same. In your case: Write Publisher instead of Filter
  2. Place your cursor in your data table. Excel selects the whole data range automatically.
  3. Go to DataSort & FilterAdvanced
  4. Under criteria range: Select the whole criteria range including the header
  5. Choose if you want to filter the data in place or copy the result to a new range.
    A single cell is enough.. Excel will expand the range automatically.

enter image description here Apologize for the non-english language dialog. But I guess, you will get the point.


To avoid the partial match problem that Publisher 1 will also match Publisher 10,
use ="=publisher 1" instead of publisher 1 in your criteria range (thx chuff)

  • 2
    To limit the filter result to include only publisher 1 and not publisher 10, enter the publisher 1 entry in the criteria range as ="=publisher 1". This avoids the default behavior of making a partial match on the criterion.
    – chuff
    Jul 1, 2013 at 13:30

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .