Sep 28 2021 12:11 AM
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.
Sep 28 2021 08:43 AM
More or less searchable drop-down list is in Excel for web so far, for the rest you shall use workarounds. With Enter.
Jun 06 2022 11:47 PM