| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Define Dynamic Name
I am trying to define a dynamic name for a drop down menu. I have a
worksheet named TST Week with a list of dates starting in cell A3 (Date header in A2, nothing in A1). I would like to be able to add indefinite more dates in the future in column A and have those show up on the drop down menu as they are added as well as all the previous dates. However, when I try this equation, it evaluates to an error. =OFFSET(TST Week!$A$1,COUNTA(TST Week!$A:$A),0,COUNTA(TST Week!$A:$A)-1,1). Where am I going wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dynamic search in the Define Name window | Excel Discussion (Misc queries) | |||
| Dynamic Formula with Dynamic Address | Excel Worksheet Functions | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Threaded Mode
