Pivot Label Filter in Excel 2007
Hi,
I have a speadsheet of invoices which consists of Date, Invoice, Invoice-Code and amount. I use a pivot to list the total invoiced per Invoice-Code, but need to exclude codes that contain words like "Bond" and "DC". The filter works fine if I select one word only. Can I and if so, how do I add more that one word to the filter? Thanks Hennie |
All times are GMT +1. The time now is 11:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com