You can use any excel range as table argument in NL(Rows).
But is is possible to filter as well?
NL("Rows";A1:A6) e.g. will produce six rows.
But in the range A1:A6 are values I don't want to report all the time.
I'd like to present the user with the option to select from that list one or more options.
On the option sheet you can use the same range in NL(Lookup) to present the list op posibilities.
Let say the choosen value is in B5.
But how do you use that value in the NL(Rows)?
The trouble is that there is no field to filter on.
NL("Rows";A1:A6;;"??????";B5)
Is it even possible to put something useful instead of the question marks?
Or will any argument after the table argument be ignored when an excel range is used? (Which seems the case based on my experience so far….)
rmw
Date
Votes
2 comments
-
Jet Reports Historic Posts The only way I can think of doing this is with some dynamic range trickery.
It's a complete hack and work around, but maybe the attached will get you out of a bind? -
Job Wintjes Hello,
Whilst our company is still using JET - REPORTS I am looking (10 years later) for a solution on this topic.
Is there any option to filter out "Green" in this custom range?
Please sign in to leave a comment.