Forum Discussion
Solved
Filtering Columns of Data (Named Ranges) based on Brand Names
Hi Everyone, I am trying to filter columns of data (named ranges) that are on same Excel spreadsheet based on brand names... I want the results of what have been filtered on a different spreadsheet....
See Sheet2 in the attached version. If it is not what you want, please explain.
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.