Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
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 '13 at 9:33

1 Answer 1

up vote 2 down vote accepted

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.

Edit

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)

share|improve this answer
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 '13 at 13:30
    
Thanks @nixda. Works great. –  user13653 Jul 8 '13 at 12:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.