Dec 01 2021 12:31 PM
I have a table in excel having 6000 lines, 7 columns using a filter =FILTER(B5:H6000,ISNUMBER(SEARCH(K2,B5:B6000)),"No results")
It includes lists containing the search value, but not only the beginning value. How can I make it list only values that begin with my search value listed in K2?"
Dec 01 2021 12:42 PM
Dec 01 2021 01:39 PM
I appreciate your efforts, but it Ends up as #VALUE!
Dec 01 2021 02:09 PM
Dec 01 2021 02:12 PM