Hopefully this is pretty simple and I am just not getting the syntax correct. I have a value on my sheet that I am pulling from the options sheet, my NL works fine if I was looking for equal to that value, however, I want not equal and it puts the <>$d$4 all in quotes - is there a trick so it pulls in the value of the D4 cell rather than comparing to the literal $d$4?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Patty,
You just want to do something like this I think:
"<>"&$D$4
Does that work for you?
Regards,
Hughes
Please sign in to leave a comment.