Hello,
I try to do the following:
I have a list of filter (let's say A1, B1, and C1) from which I want to retrieve the union of the result and to have the result in a filter
It is possible to do NL("Rows"; NP("Union"; A1;B1;C1)) and get a list
But it is not possible to have it in a Filter as
NL("Filter"; "Table"; "Field"; "Field"; NP("Union";A1;B1;C1))
Can you help?
Regards,
Mat
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Mat,
You actually can use NP(Union) as a filter in an NL(Rows) function. You just can't do so in an NL(Filter) function.
You can use NL(AllUnique) instead of NL(Filter) in this case. NL(AllUnique) works just like NL(Filter), except that it must be embedded inside another Jet function such as NL(Rows) or another NL(AllUnqiue). It won't work if it's sitting in its own cell instead of embedded. Also, you can't embed an NL(AllUnique) inside an NL(Filter) or visa versa. Does this work for you?
Regards,
Hughes
Please sign in to leave a comment.