Forum Discussion
ChrisAntico
Dec 09, 2021Copper Contributor
Search field - blank cell
Im working on a project for work to keep inventory of the various inks we have. My issue is with the search filter. I can filter my search and generate the request, however when I leave the search fi...
HansVogelaar
Dec 09, 2021MVP
Change the formula to
=FILTER(C4:E169,(K4<>"")*ISNUMBER(SEARCH(K4,C4:C169)),("No Results"))