Forum Discussion
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.
See Sheet2 in the attached version. If it is not what you want, please explain.
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.
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
- Yes... This works, thank you!!