Forum Discussion

PeteSauces's avatar
PeteSauces
Copper Contributor
Apr 16, 2024
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....
excel
Formulas and Functions
office 365
PeteSauces's avatar
PeteSauces
Copper Contributor
Apr 21, 2024

HansVogelaar 

 

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

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 21, 2024

    PeteSauces 

    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.

Resources