Google Answers Logo
View Question
 
Q: PivotTables in Microsoft Excel 2002 ( No Answer,   1 Comment )
Question  
Subject: PivotTables in Microsoft Excel 2002
Category: Computers > Programming
Asked by: thomasmc6050-ga
List Price: $3.00
Posted: 22 Feb 2003 23:00 PST
Expires: 24 Mar 2003 23:00 PST
Question ID: 165882
In Microsoft Excel 2002, is it possible to compare data from TWO
PivotTables? These tables have different sources and the fields I need
to compare are both a sum. Also, I'm not just comparing two individual
cells or I would use the GetPivotData Function. I need to compare a
column of row sums to multiple rows of column sums. If this is
unclear, I would be happy to email an example.
Answer  
There is no answer at this time.

Comments  
Subject: Re: PivotTables in Microsoft Excel 2002
From: leskowitz-ga on 26 Mar 2003 21:14 PST
 
I am on an excel roll.  Without seeing the tables it is hard, you
could try to using some vlookups.  I am assuming both tables have the
same key viewed to compare.  Next to one of the table put a vlookup
looking for the key field, select range of the other table and count
to the sum field, remember to include "false" at the end for an exalt
match.  That is how I would do it.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy