Forum Discussion
Solved
Search box filter
Hi. I created a search box in Excel 365 watching a youtube video. I can search a column by LEFT or RIGHT (so words beginning with or ending with), but I’d like to be able to search the entire cell...
Use something like
=FILTER(fileName, ISNUMBER(SEARCH(search_term, fileName[columnName])), "No Results")
Use something like
=FILTER(fileName, ISNUMBER(SEARCH(search_term, fileName[columnName])), "No Results")
- YES!! It worked!! Thank you!!!
