Forum Discussion

Frank145's avatar
Frank145
Brass Contributor
Dec 17, 2022

Exclusion filter

Hi The formula below works fine. What I wanted to do is add an exclusion of “OOS” and “OTS-Build” categories within the same (Table13910), within the [WAVE] column. Ideally give me “Yes” fro...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Dec 17, 2022

Frank145 

Does this do what you want?

 

=FILTER(Table13910[Tags],(Table13910[EOL WL]="Yes")*(Table13910[WAVE]<>"OOS")*(Table13910[WAVE]<>"OTS-Build"),"")

  • Frank145's avatar
    Frank145
    Brass Contributor
    Dec 17, 2022
    Perfect!

    This works great.

    Thank you so much.

Resources