Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Creating a Filter to include XX* but exclude *YY

Overview

If you want to create a filter to include everything that starts with XX, but exclude everything that ends in YY, you have to use a combination of NL("Filter") and NP("Difference") functions.

For example:

You want a list of Job Numbers that begin with XX, but exclude all the job numbers that end in YY:

=NL("Rows","Job","No.","No.",NP("Difference",NL("Filter","Job","No.","No.","XX*"),NL("Filter","Job","No.","No.","*YY")))

Published:

Creating a Filter to include XX* but exclude *YY

Overview

If you want to create a filter to include everything that starts with XX, but exclude everything that ends in YY, you have to use a combination of NL("Filter") and NP("Difference") functions.

For example:

You want a list of Job Numbers that begin with XX, but exclude all the job numbers that end in YY:

=NL("Rows","Job","No.","No.",NP("Difference",NL("Filter","Job","No.","No.","XX*"),NL("Filter","Job","No.","No.","*YY")))

For an optimal Community experience, Please view on Desktop