![]() |
|
![]() | ||
|
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. |
![]() | ||
|
There is no answer at this time. |
![]() | ||
|
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. |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |