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.
I’m using =filter(fileName,LEFT(fileName[columnName]…
^^ shows words beginning with …and if I change LEFT to RIGHT, then it searches for words ending in..
Thank you!
Use something like
=FILTER(fileName, ISNUMBER(SEARCH(search_term, fileName[columnName])), "No Results")
2 Replies
Use something like
=FILTER(fileName, ISNUMBER(SEARCH(search_term, fileName[columnName])), "No Results")
- YES!! It worked!! Thank you!!!
