In the "Comment Line" table I have several records. I want to do this:
Cell AH48: The last record, field "Comment"
Cell AH49: The second to last record, field "Comment"
…
Cell E24 = 4854
In AH48 I have: =NL(-1;"Comment Line";"Comment";"Table Name";"Job";"No.";4854) This works and gives me the last record.
In AH49 I have: =NL(-2;"Comment Line";"Comment";"Table Name";"Job";"No.";$E$24) This gives me the first record.
In AH50 I have: =NL(-3;"Comment Line";"Comment";"Table Name";"Job";"No.";$E$24) This gives me the first record.
What number i put in the "what", (-1, -2, 5) doesn't have any effect when job nr is refered to a cell, not the actual number.
Any tips?
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Looks like is has something to do with macroes we are running in Excel, not Jet it self.
-
Jet Reports Historic Posts Why you are not just using DESCENDING sort?
Please sign in to leave a comment.