![]() |
|
#2
|
|||
|
|||
|
A foolproof way to define dynamic named ranges is to use OFFSET().
E.g. Code:
=OFFSET(AnchorPoint, RowsDown, ColumnsRight, NumberOfRows, NumberOfColumns) AnchorPoint is address of some single cell which you are sure it will never be deleted, and is above or in same row as the range you want to define, and left or in same column as the range you want to define; RowsDown is the number of rows from AnchorPoint to topmost row of range you want to define; ColumnsRight is the number of columns from AnchorPoint to leftmost column of range you want to define; NumberOfRows is the number of rows you want in defined range; NumberOfColumns is the number of columns you want in defined range. E.g. you want to define a range P5:P1, anchored to cell P1: Code:
=OFFSET($P$1,4,,6,1) To get any detailed help you have to attach some example table here. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Creating a dynamic array for some formulas | Bumba | Excel | 2 | 01-27-2019 05:10 AM |
| Fixing legend of a dynamic chart | Toonook | Excel | 0 | 08-25-2016 04:46 PM |
Dynamic chart ranges
|
GlowingApple | Excel | 1 | 02-17-2016 07:18 PM |
| Generating a chart with dynamic series | Officer_Bierschnitt | Excel | 3 | 10-15-2015 12:30 AM |
| Dynamic Chart with Non Continuous data | swati_04 | Excel | 0 | 03-02-2015 12:06 AM |