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.