I'm trying to filter using the following cell refferences. I'm having an issue finding the right combinations of " and "" to make the Less than and Greater than work...
=NL("rows","Sales Line",,"Document No.",$E12,"Line No.","">""&$G12&""<""&$H12)
Date
Votes
2 comments
-
Jet Asia Support Hi Robert,
You may need to add an additional column in you report. lets say column I, in column I you need to define an excel if else condition.
You can then hide column I by using inserting the "Hide" keyword in cell I1.
Your NL condition then would be =NL("rows","Sales Line",,"Document No.",$E12,"Line No.",$I12)
I hope this information helps.
regards,
Sanket
-
Cat Hi Robert,
for me your condition for "Line No." does not seems correct.
Assuming $E12 would be 10000 and $H12 40000 your filter would result in false instead of a filter text >10000&<40000 (or >10000|<40000 - don't know really what you want to see).
Try it with =NL("rows","Sales Line",,"Document No.",$E12,"Line No.",">"&$G12&"&"&"<"&$H12) or =NL("rows","Sales Line",,"Document No.",$E12,"Line No.",">"&$G12&"|"&"<"&$H12)
Please sign in to leave a comment.