Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to have a multiple search criteria in Excel?

Is there any way to use logical constructs like OR etc. in filter criteria of a pivot table?

Update : In the filter options ( when one click the triangle in the caption of the field) the filter for "Begins With:" can only be used to filter only on one set of characters, e.g. find all the items that begin with "ABC" only, but I want to filter the items that beging with "AB" or CD" only.

In Sql this is a no brainer with the "like 'AB%' or like 'CD%'" , but I want to do the filtering in the pivot table.

share|improve this question
You can use advanced filters. What exactly are you trying to accomplish? Some details would be helpful in determining how you can accomplish it. – Raystafarian Feb 29 '12 at 11:04
@Raystafarian : In the Pivot table, With any text field, when trying to filter there is only one way of filtering "Begins with" and there is no wat to say filter Items begining with "K" and "C" only. – Arjang Mar 3 '12 at 3:51
Use filters instead of a pivot table – Raystafarian Mar 3 '12 at 12:15
@Raystafarian : Ray, I have the data in the Pivot table, That is how they are eant to be summurized. What do you mean to use Filters instead of PT? I just want to get the results that match a criteria in the Pivot Table. – Arjang Mar 3 '12 at 19:46

Try filtering on at least one blank row above Pivot Table as well as Pivot Table.

share|improve this answer

You must log in to answer this question.

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