Forum Discussion
Re: Filtering Columns of Data (Named Ranges) based on Brand Names
See Sheet2 in the attached version. If it is not what you want, please explain.
3 Replies
Another quick question to another problem:
I don't want the filtered results to include results that include words/brands in which, "the word is in a part of another word"....For example, if the filter criteria is "Protect" and one of the products is "Speaker with 10-Year Protection Plan", is there any way to filter using only the word "Protect"...
Peter
Use
=LET(f, VSTACK(FILTER(productLists, ISNUMBER(SEARCH(" "&A1&" ", " "&productLists&" ")), ""), FILTER(Clearance_Products, ISNUMBER(SEARCH(" "&A1&" ", " "&Clearance_Products&" ")), "")), FILTER(f, f<>"", ""))
See the attached version.
- Yes... This works, thank you!!
