Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find a cell address from a GETPIVOTDATA() Fomula
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find address of active cell | Excel Worksheet Functions | |||
Is there a way to find the address of a cell with a certain value? | Excel Worksheet Functions | |||
Function to find the address of a cell | Excel Worksheet Functions | |||
Lookup ADDRESS of GETPIVOTDATA Subtotal/Cell | Excel Worksheet Functions | |||
How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) |