Hello All,
I have 3 arrays that I want to intersect with NP("Intersect";$B$2;$B$3;$B$4)). I want to use this function as a filter. Problem is that it does not work. I can make an intersect with any 2 out of the 3 arrays but not with 3. The intersect does not work but when I use Union the formula runs okay except that I do not want a Union I want an Intersect. Anyone any ideas or work arounds
Arnoud Rottinghuis
Date
Votes
2 comments
-
Jet Reports Historic Posts Arnoud,
From reading the documentation, and looking at the Jfx, it seems to me that the Intersect was only designed to work with 2 arrays. I think I need someone to check my logic, but wouldn't the following formula work.=NP("Intersect";NP("Intersect";$B$2;$B$3);NP("Intersect";$B$3;$B$4)) -
Jet Reports Historic Posts Bingo! Works fine.
Thanks,
Arnoud
Please sign in to leave a comment.