Thread: Pivot Table - with blank rows
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Pivot Table - with blank rows
HMallen,
Value Filter and Label Filter
can be applied at the same time.
In PT Options, check: Allow multiple filters per field.
Here is ColG's modified example:
http://www.savefile.com/files/1905362

Reply With QuoteReply With Quote