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.
- Let’s please assume that all products are being filtered using a single search criteria which will be listed in the heading of each column…
- Please keep in mind that this is not the actual project, in other words, the actual project has much more information and is completely different than this… but in order to remain anonymous I looked up the names of different products and listed them in the files…
In A2 on the second sheet:
=LET(f, VSTACK(FILTER(productLists, ISNUMBER(SEARCH(A1, productLists)), ""), FILTER(Clearance_Products, ISNUMBER(SEARCH(A1, Clearance_Products)), "")), FILTER(f, f<>"", ""))
Fill to the right.
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!!
See Sheet2 in the attached version. If it is not what you want, please explain.
Sorry, you've lost me again. What exactly do you want?
