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
 
Ad

Advertisements

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.
 
Ad

Advertisements


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

Top