My Account
Sign up, and you'll be able to customize your font size and more!
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
May 22, 2015
10:53
:38
am
Blue Print
Also you can use GetPivotData() as follows:
=GETPIVOTDATA("Sum of Value",$A$3,"Name","John")
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
Blue Print
Bio page
Blue Print
Joined
Sep 7, 2001
Last login
Apr 25, 2024
Total posts
29,189 (5,432 FO)
Report problem with this ad
Messages
Author
Time
Excel experts - having trouble with INDIRECT()
BYUCoug11
5/22/15 10:18am
You can't use indirect with a pivot table.
Blue Print
5/22/15 10:52am
Also you can use GetPivotData() as follows:
Blue Print
5/22/15 10:53am
I'm using it in a different column with pivot data without issue
BYUCoug11
5/22/15 11:03am
Report problem with this ad
Posting on CougarBoard
In order to post, you will need to either
sign up
or
log in
.
Report problem with this ad