98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Filtering and Pivot tables
Advanced Filtering and Pivot tables
Resolved · Urgent Priority · Version 2003
Wed 17 Sep 2008, 17:05Delegate Hajer said...
Hajer has attended:
Excel Advanced course
Advanced Filtering and Pivot tables
how can I use Advanced Filtering and Pivot tables together
Thu 18 Sep 2008, 09:03Trainer Greg said...
RE: Advanced Filtering and Pivot tables
Hello Hajer,
To answer your question, you have to use Advanced filtering and Pivot tables separately as you canoot use them together.
When you construct a Pivot Table, the original table is a data source and a new table is formed. You can do Advanced Filtering with the original data (data source) whilst you still got the Pivot Table on another worksheet.
I hope this answers your question. If it doesn't, please get back to me.
Thank you
Greg
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:COUNT function vs COUNTA functionThe COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function. |
