Ok so I have this cell that uses a list as validation. So my list has maybe a 100 items in its and I would like it so that if I started typing in the cell options from the list start appearing. So for example, if I had a list:
Jackson
Johnson
Jones
Williams
Smith
and I started typing ‘J’ then the drop down list would shrink to just the first entries. And then when I typed an O it would just have Johnson and Jones and finally when I typed an H it would just show Johnson.
For an example look at this webpage
and hover over Players in the bar above the main content. An entry box appears and if you start entering letters it gives you options.
Is this at all possible?