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 » Pivot Tables
Pivot Tables
Resolved · Low Priority · Version 2007
Wed 1 Jul 2009, 16:18Delegate Debbie said...
Debbie has attended:
Excel Advanced course
Pivot Tables
What is the best/quickest way to reconcile two pivot tables with similar data?
Fri 3 Jul 2009, 10:01Trainer Stephen said...
RE: Pivot Tables
Hi Debbie
Thank you for your question
Could you please clarify what you mean by reconcile for me? Do you wish to compare two pivot tables with the same row and column headings? If so what is the nature of the comparison, e.g. do you wish to see the difference between the values, or perhaps one as the percentage of another
Thanks
Stephen
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:Conditional formatting for cells that return text , not picked up by Go to commandIf you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text. |
