Find a cell address from a GETPIVOTDATA() Fomula
 

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

Find a cell address from a GETPIVOTDATA() Fomula
 

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.
--
http://www.ExcelHelp.us

Call me at
1-888-MY-ETHER ext. 01781474



"Kevin" wrote:

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

Find a cell address from a GETPIVOTDATA() Fomula
 

Excel 2007
This finds the row label,
but it uses a macro:
http://www.savefile.com/files/1867201