GETPIVOTDATA() with relative reference
 

Hi,

Is there a way of cheating GETPIVOTDATA() into using a cell reference as the
data field argument? As in =GETPIVOTDATA(J8;$A$7;"Rep";$J$9:$L$9). I've tried
with just about every function I can think to get the text from J8 used in
the formula instead of having to write the text.

Any hints?

/Sune

GETPIVOTDATA() with relative reference
 

"Sune Fibaek" wrote:
Is there a way of cheating GETPIVOTDATA() into using a cell reference as the
data field argument? As in =GETPIVOTDATA(J8;$A$7;"Rep";$J$9:$L$9). I've tried
with just about every function I can think to get the text from J8 used in
the formula instead of having to write the text.

The T function seems to work ok when I tested it lightly,
so we could try: =GETPIVOTDATA(T(J8);$A$7;"Rep";$J$9:$L$9).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

GETPIVOTDATA() with relative reference
 

"Max" wrote:

The T function seems to work ok when I tested it lightly,

Obviously!! That's exactly what, I was looking for!

Thank you.

/Sune

GETPIVOTDATA() with relative reference
 

The T function seems to work ok when I tested it lightly,

Obviously! That was exactly what, I was looking for.

Thank you.

/Sune

GETPIVOTDATA() with relative reference
 

Glad to hear that !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sune Fibaek" wrote:
The T function seems to work ok when I tested it lightly,

Obviously! That was exactly what, I was looking for.

Thank you.

/Sune

GETPIVOTDATA() with relative reference
 

Hi

Thank you Max the T() Function Worked like a Charm to the same query I
posted earlier on this morning, and found the solution on this query.

Thanks

Roger Ramseier


Max wrote:
"Sune Fibaek" wrote:
Is there a way of cheating GETPIVOTDATA() into using a cell reference as the
data field argument? As in =GETPIVOTDATA(J8;$A$7;"Rep";$J$9:$L$9). I've tried
with just about every function I can think to get the text from J8 used in
the formula instead of having to write the text.

The T function seems to work ok when I tested it lightly,
so we could try: =GETPIVOTDATA(T(J8);$A$7;"Rep";$J$9:$L$9).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

GETPIVOTDATA() with relative reference
 

Glad it fit the bill for you too, Roger ! Cheers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Roger The Rabbit" wrote:
Thank you Max the T() Function Worked like a Charm to the same query I
posted earlier on this morning, and found the solution on this query.

Thanks

Roger Ramseier