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.

The example given below is very unintuitive and difficult to use. Why not allow something like this and then the designer could parse and convert it behind the scenes

NL("MultiArray", "Job", "No.", "Difference", "No.", "XX*", "*YY")

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")))