View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AJk AJk is offline
external usenet poster
 
Posts: 11
Default Label Filter in Pivot Tab;e

I want to filter text in a series field in a pivot table by multiple
criteria. I am using the "contains" comparison operator but want to filter
on something like "Mike or Jim" to get all text that contains either name. I
really need to filter by 3 or 4 pieces of text (Mike or Jim or Joe or John).
The alternative is to unselct everyhting and go in and find each name but I
have almost 50,000 records so it is quite long. Thanks for any help you can
offer.

Joe