Forum Discussion

samery's avatar
samery
Copper Contributor
Oct 27, 2023
Solved

Filter function

hi I have one table called metadata contains 3000+ rows of variables grouped in some classification.   I want to use Filter function to return all variables from Metadata (Name + Description) wher...
excel
  • djclements's avatar
    djclements
    Oct 27, 2023

    Riny_van_Eekelen That's quite the formula! :suprised: I like it, although a simple COUNTIF or ISNUMBER/XMATCH with the parameters reversed will suffice...

     

    =FILTER(MetaData[[NAME]:[DESCRIPTION]], COUNTIF(K7#, MetaData[CLASSIFICATION 1]), "")
// OR:
=FILTER(MetaData[[NAME]:[DESCRIPTION]], ISNUMBER(XMATCH(MetaData[CLASSIFICATION 1], K7#)), "")

     

    Cheers!

     

     

  • samery's avatar
    samery
    Copper Contributor
    Oct 27, 2023

    peiyezhu 
    thanks for your response. I think the page you provided works if you know the target strings you are searching for. But in my case they are not known. Hence I won't be able to write individual strings in the index function. 

Resources