Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expanding a data table to include an extra row
I need to expand a data table (or 'special array' as referred to in this
discussion group) to include an additional row. Previously I have been shown how to do this and it worked then, but have forgotten how too!! Across the top of the array are dates (cells D16 - J16) and on the far left of the array is formula referencing to a different sheet in the workbook. I have selected the current array (using Go To - Special - Current Array) and then expanded it for the additional line I need; also adding in the appropriate formula that I require on the far left - pressed F2 and then CTRL - SHIFT - ENTER and it keeps populating with hard coded text! I am sure this is an easy thing to do... any advise would be appreciated!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expanding a data table to include an extra row
Create a dynamic range name for the range and use that in the formula.
See http://www.contextures.com/xlNames01.html#Dynamic -- __________________________________ HTH Bob "HRobinson" wrote in message ... I need to expand a data table (or 'special array' as referred to in this discussion group) to include an additional row. Previously I have been shown how to do this and it worked then, but have forgotten how too!! Across the top of the array are dates (cells D16 - J16) and on the far left of the array is formula referencing to a different sheet in the workbook. I have selected the current array (using Go To - Special - Current Array) and then expanded it for the additional line I need; also adding in the appropriate formula that I require on the far left - pressed F2 and then CTRL - SHIFT - ENTER and it keeps populating with hard coded text! I am sure this is an easy thing to do... any advise would be appreciated!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change my data or add extra rows in a Pivot Table for Ex. | Excel Discussion (Misc queries) | |||
Counting Last n Rows in Expanding Table | Excel Discussion (Misc queries) | |||
In a pivot table, can the avg of a column include rows w/o data? | Excel Discussion (Misc queries) | |||
Excel formula in an expanding table | Excel Discussion (Misc queries) |