Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Multiple Cell References in GetPivotData
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Debra Dalgleish, post: 3704745"] What's the field name for the column headings? The numbers, -3, -2, etc., look like field items, not field names. In the formula, use a field name, space, item name. For example, if the field names are MonthDiff and Client Ref: =GETPIVOTDATA(Pivot!$A$4,"MonthDiff -3 'Client Ref' 1234") To use cell references, where the MonthDiff item is in A6, and the Client Ref item is in C6: =GETPIVOTDATA(Pivot!$A$4,"MonthDiff " & A6 & " 'Client Ref' " & C6) [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Multiple Cell References in GetPivotData
Top
