Filtering...

Hi all. Hopeing somebody can help me out… I'm producing a simple-ish sales report. The idea is one sheet per sales rep and selecting the reps based on region, which we are storing in global dimension 1 code.

Here is the formula as it stands:

=nl("Sheets","Customer","Salesperson Code","Global Dimension 1 Code",D3,"Salesperson Code","<>@@","Blocked",0,"No.",nl("Filter","Cust. Ledger Entry","Sell-to Customer No.","Posting Date",$D$7,"Sell-to Customer No.","<>@@"))
Basically there are some Salesperson Codes that are returned which I do not want returned. Specifically two values. I have tried all sorts of combinations of filtering but I can't get what I want to occur.

If I try "Salesperson Code","<>@@&HOUSE&1", I get the same result as "<>@@"
If I try "Salesperson Code","<>@@|HOUSE|1", I get the same result as "<>@@"
if I try "Salesperson Code","<>@@&<>HOUSE&<>1" I get #value
if I try "Salesperson Code","<>@@|<>HOUSE|<>1" I get #value

I want to avoid hard coding the inclusions, hence why I'm trying to only hard code the exclusion (as they are unlikey to change anywhere near as much).

Any help would be much appreciated