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

Add Item to Data List that has Dynamic Source
 

A possible option is to extract the names that meet the condition to another
list that starts with an empty cell. For example. if these are the names
that meet the condition:

Adams, Bob
Adams, Charlie
Adams, Sue

Then you would extract those names to another range where the first cell is
empty:

X1 = empty cell
X2 = Adams, Bob
X3 = Adams, Charlie
X4 = Adams, Sue

Then the source for your drop down would be X1:X4.

--
Biff
Microsoft Excel MVP


"RikNeedsHelp" wrote in message
...
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