| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Item to Data List that has Dynamic Source
I have a dynamic drop down list that refers to a long column of names, sorted
alphabetically. The list will size itself depending on the letters entered into a reference cell (A1). ResList is a named range that references to the column origin, and ResName is the dynamic named range of the column of names. The source equation is this: =OFFSET(ResList,MATCH(A1&"*",ResName,0),0,COUNTIF( ResName,A1&"*"),1) Question: is it possible to insert a blank as the first selectable item in the resulting list - without VB? -- Kind regards Rik |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic source data based on Today | Charts and Charting in Excel | |||
| Dynamic PivotTable Data Source | Excel Discussion (Misc queries) | |||
| Need Dynamic Data source help | Charts and Charting in Excel | |||
| Dynamic source list to auto expand | Excel Discussion (Misc queries) | |||
| Dynamic references in diagram source data? | Excel Discussion (Misc queries) | |||
Threaded Mode
