» Retrieving Data from a PivotTable Report
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
To retrieve data, use the GETPIVOTDATA formula:
In Excel 2002 and Excel 2003, it is much easier to use the GETPIVOTDATA formula. Simply select any cell outside the PivotTable report, press the equals (=) sign and select a cell in the PivotTable report's Data area.
In Excel 97 and Excel 2000, insert the formula by manually typing the data field name and the fields.
To retrieve data when the structure of the PivotTable Report is stable, use either:
The INDEX formula combined with the MATCH formula. The defined Names used in the formulas are:
* PivotTableSheet: The name of the entire sheet.
* ColA: Column A.
Note: The number 2 in the MATCH formula stands for column B, which is column 2 in the sheet.
The SUMIF formula combined with the OFFSET formula.
Note: The number 1 in the OFFSET formula stands for one column from the reference address, which is column A.
Book Store:
Recommended Books:
- Marketing Plan: A Handbook with Marketing Plan
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- PowerPoint® 2002 For Dummies®
- The Guide to Understanding Financial Statements
- Investing in Real Estate, Fourth Edition
No comments have been submitted.
