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     www.energyefficientbuild.com.   Jan-02-2016

post by: emacrisema:

https://productforums.google.com/forum/#!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 .

https://docs.google.com/spreadsheets/d/1T7VNgJrF1yr7HKeV-34xiKRyGoScyuxqdfBnleVU4HA/edit?usp=sharing

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 :)