| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getpivot date w/ relative reference
I am or have been attempting to extract data from a pivot table. I would
like to use a reference in "sheet 1" cell $A1 as the "item" in the getpivotdata (the pivot table is in a separate sheet) formula below. =GETPIVOTDATA("3Q06",$A$3,"Linking - Building code","11") =GETPIVOTDATA(data_field,pivot_table,field1,item) all my efforts have resulted in #ref results. Any insight would be greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| picture relative to cell reference | Excel Discussion (Misc queries) | |||
| search for latest date | Excel Worksheet Functions | |||
| reference to a bimonthly date | Excel Discussion (Misc queries) | |||
| How Do I Get a date reference when linking excel worksheets? | Excel Worksheet Functions | |||
Threaded Mode
