View Single Post
  #1  
Old November 13th, 2009, 09:54 PM posted to microsoft.public.excel.misc
Ryan
external usenet poster
 
Posts: 551
Default make my own list like formula autocomplete

I have a list of 1000s of items and i want the same formula that was used to
make the formula autocomplete. I want to start typing and a list drops down
of all the avaliable options. Like if in my list is apple and appricot i
want to type a and both of them appear in a list. It is for my squadron
commander and i cant figure it out. Any help is much appreciated.