Find a cell address from a GETPIVOTDATA() Fomula

K

Kevin

Hi

Is it possible to find the address of a cell from the GETPIVOTDATA() formula.

Basically I want to find the value in a pivot table which is one cell to the
left of the values. The GETPIVOTDATA() function ensures I can always refer to
the correct value no matter where in the pivot table it appears but I also
need the value in the row label to the left of the value

Any ideas
 
G

galimi

Kevin,

You could break up the GETPIVOTDATA formula via a function/subroutine which
parsed out the different components. You could then navigate through the
pivot table doing a match against the value you are seeking and then use the
offset method to grab the value to the left.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
2007 Excel - GETPIVOTDATA 2
getpivotdata doesn't like certain numbers?? 2
using GETPIVOTDATA feature and need to keep formatting 1
GETPIVOTDATA from OLAP cube - grouped field 0
Pivot Table GETPIVOTDATA 2
ISERROR on GETPIVOTDATA 1

Top