0

Help with not equal

The following statement returns rows where the Variety Code is equal to the 3rd and 4th characters of the Code.  What I really need is to return the rows where the Variety Code is NOT equal to the 3rd and 4th characters of the Code.  I'm struggling with getting the syntax correct. 

=NL("Rows","Batch",,"=NF(,""Variety Code"")","=MID(NF(,""Code""),3,2)")

Thanks.

8 comments

Please sign in to leave a comment.