Saturday, January 2, 2016

yogi_Create A DropDown List From Stock Items In A:A Based On Specified Search Criteria

Google Spreadsheet   Post  #2003
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-02-2016
post by: emacrisema:!topic/docs/jyeAVREGN4s;context-place=mydiscussions
Create dropdown options from a single cell's content ?
Is it possible to do that ?
I need the letters in A1 or B1 to become options in a dropdown WITHOUT using split.
I tried to use split but it's simply not feasible.
I  have thousands of rows with hundreds of lines in each cell .

I saw there is an option for custom formulas but even if I could get it to work the option for dropdown is disabled under custom formula.

Thanks :)