Find a cell address from a GETPIVOTDATA() Fomula

  • Thread starter Thread starter Kevin
  • Start date Start date
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
 
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.
 
Back
Top