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.