| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic range name
In a dynamic range name, I'd like to to refer to the entire column that
another named range is in. So in the name "Refers To" below, instead of "Sheet1!$E:$E" I'd like to be able to say "the column in which the cell Amount is": =OFFSET(Amount,1,0):OFFSET(Amount,COUNTA(Sheet1!$E :$E)-1,0) Thanks, Doug |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WEEKNUM to dynamic range name | Excel Worksheet Functions | |||
| Can't chart dynamic named range?? | Charts and Charting in Excel | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Threaded Mode
