| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic Non Consecutive Named Range?
I have a single column of data AJ11:AJ58 which contains a formula that
results in OPEN or CLOSED. I need to reference this column in multiple formulas as well as in the X Axis of a chart. Not only do these values change, but they are also not necessarialy consecutive. For example, one pass results in a range of OPEN cells (which is what I need to reference) of AJ25:AJ52 and another common pass results in AJ11:AJ12,AJ21:AJ58. Is there a way to name this dynamic range so I can reference it as described? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using a dynamic named range in a VLOOKUP | Excel Discussion (Misc queries) | |||
| Problem with Dynamic Named Range | Excel Worksheet Functions | |||
| Can't chart dynamic named range?? | Charts and Charting in Excel | |||
| Dynamic named range & Offset | Excel Discussion (Misc queries) | |||
| Dynamic Named Range | Charts and Charting in Excel | |||
Hybrid Mode
