Hi,
Following code is working fine except the filter for nr. there is no error, the code is working but it does not exclude the Nr. from range ver!$E$5:$E$97"+nr.";"<>ver!$E$5:$E$97";"Niveau"=NL("Rijen";"Project configuratieregel";;"Projectnr.";$L$5;"+Pad indicatie";$L$10;"+Afdelingscode";$L$9[b];"+nr.";"<>ver!$E$5:$E$97";"Niveau";[/b]$L$8;"soort";"artikel";"aantal";$L$12)
some help is appriciated to solve it
thanks
Jan
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Jan,
i think it's not working because you can't filter to an excelrange this way.
i would join the entries from "ver!$E$5:$E$97" in one separate cell (f.e. "$f$5") with "<>".
so you will get a string like "<>value1<>value2<>value3<>……"
then change your filter from "+nr.";"<>ver!$E$5:$E$97" into "+nr.";"ver!$F$5".
does that work for you?
regards
jetsetter -
Jet Reports Historic Posts In a smiliar way to what has been previously suggested, this should work:
=NL("Rijen";"Project configuratieregel";;"Projectnr.";$L$5;"+Pad indicatie";$L$10;"+Afdelingscode";$L$9;"+nr.";"<>&"&NP("Join";ver!$E$5:$E$97;"&<>");"Niveau";$L$8;"soort";"artikel";"aantal";$L$12) -
Jet Reports Historic Posts the join was the solution
thanks
Please sign in to leave a comment.