Filter data validation options by typing in google sheets

0

So I have in google sheets, a drop down list populated using data validation (created via script).

enter image description here

In the drop down cell when you start typing, it will filter the available drop down options based on what you have entered so far.

enter image description here

But it only shows valid options if you enter characters from the beginning of the data.

My question is, is it possible to have it filter the list by substring, rather than starts with string?

For example in the sample data, if I typed in 'ee' I would want it to show me all the list options that have a 'ee' in them (So I would be presented with 'Tree' and 'Weed' in the drop down options).

'ee' shows no options because none start with 'ee' even though two contain it

Is this possible?

unknownSPY

Posted 2019-07-26T11:43:05.143

Reputation: 296

No answers