View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RikNeedsHelp RikNeedsHelp is offline
external usenet poster
 
Posts: 3
Default 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