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)),"nothing found")
If I put in a search string I MUST press enter in order to get results. Is it possible to get a filtered result without pressing enter? I'm using a Mac and Excel 365.
2 Replies
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
