| 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 |
| 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) | |||
Threaded Mode
