Forum Discussion
Filter function dynamic array without pressing enter
Hi, I've created a searchable dropdown list in my excel sheet using the dynamic array FILTER function. Here's the formula: =FILTER(klant[Klant],ISNUMBER(SEARCH(Pickorderinvoer!B4,klant[Klant],1))...
More or less searchable drop-down list is in Excel for web so far, for the rest you shall use workarounds. With Enter.
- Hi Sergei,
I have found a solution for this use case. Many thanks for your hints
