Two Filters and return only those matches


I'm trying to produce a report based on Purchase Order numbers.


Cell D6:=@NL("Filter","Purchase Line","Document No.","Filters=",$C$4:$D$5)  'This returns a Filter of PO Numbers which match the required GL information specified in C4:D5

Cell D12:=@NL("Filter","Purch. Inv. Header","Purchase Order No.","Filters=",$C$9:$D$11)  'Again, a Filter of PO Numbers but where the dimensions and invoice receive date match those in C9:D11


I now need to combine the two lists and return only those purchase orders which appear in both Filters. And that's the bit I'm having trouble with.

  • NP(Union) merges the two lists of PO numbers into one, regardless of whether they appear in one Filter or both, and that gives me too much information.
  • NP(Interset) only works (from what I've read) based on numbers. My PO numbers are alphanumeric.
  • NP(Difference) only seems to give me PO numbers which are definitely in one list or the other, but not both. I think I need the 'anti-difference'

I'm really not sure how to make this work. Can anyone help?



Please sign in to leave a comment.