| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Absolute references in Calculated Table columns
Humphrey,
Just got the answer myself in a newer post. Use indirect to make it absolute so i.e Table_CBCC_Data[[#This Row],[dateBudget]] becomes INDIRECT("Table_CBCC_Data[[#This Row],[dateBudget]]") this will be absolute see also http://www.cpearson.com/excel/indirect.htm On 14 jan, 22:00, Humphrey wrote: I need to create an absolute reference in a calculated column so that when I copy the formula across to subsequent columns the formula continues to refer to the equivalent of $D4. How is this done using table columns? When I copy now to the next column it applies a relative reference. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Absolute References | Excel Discussion (Misc queries) | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| Absolute References | Excel Worksheet Functions | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Threaded Mode
